1

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

Improve this question

1 Answer 1

Reset to default
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
Improve this answer
6
  • so I have to create a formula to summarize the data on the child level?
    – tjcinnamon
    Commented May 26, 2016 at 17:22
  • got it! Perfect!
    – tjcinnamon
    Commented May 26, 2016 at 17:27
  • You mentioned joined report, so I assumed you are using them already
    – o-lexi
    Commented May 26, 2016 at 17:28
  • 1
    @tjcinnamon You can be interested in Passing Variables to Joined Reports in JavaScript
    – o-lexi
    Commented May 26, 2016 at 17:37
  • I'll look into it. Maybe I can incorporate a report into a lightning component?
    – tjcinnamon
    Commented May 26, 2016 at 17:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .