I have a joined report where I want to hide some of the fields because they are only used for a total. These totals are only for the Master object however they are showing up on the details as well (as they should with a standard query). However in many reporting tools, I could hide that field and display it on the group by section change of the master object.

All this duplicate data from the parent on the child details is kinda distracting

See attached to see if this is somehow possible. If it is, how do I do it?

report issue

1 Answer 1


When you edit a cross-block formula you can define this:

'Where will this formula be displayed?'

This formula calculation will be displayed in the report at the level you select.

  • All summary levels
  • Grand summary only
  • Grouping 1: Account Name
  • Grouping 2: Idea Number
  • so I have to create a formula to summarize the data on the child level?
    – tjcinnamon
    May 26, 2016 at 17:22
  • got it! Perfect!
    – tjcinnamon
    May 26, 2016 at 17:27
  • You mentioned joined report, so I assumed you are using them already
    – o-lexi
    May 26, 2016 at 17:28
  • 1
    @tjcinnamon You can be interested in Passing Variables to Joined Reports in JavaScript
    – o-lexi
    May 26, 2016 at 17:37
  • I'll look into it. Maybe I can incorporate a report into a lightning component?
    – tjcinnamon
    May 26, 2016 at 17:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.