Skip to main content
Topics#Reports & DashboardsQuestion de Rose Farnham
Rose Farnham (Big Dog Computing) a posé une question dans #Reports & Dashboards
1 mars 2016, 22:21

How to only show Grand Totals by row where the Subtotal in the Grand Total column is greater than one?

I am really trying to create a report where I can see all the Programs that were generated from a certain Program. For all the contacts that attended the DYR Workshop in February what other Programs did they register for?

 

I am using the Professional version of Salesforce and join reports are not possible. 

 

It would be nice if I could get all of the Subtotal/Grand Total that are greater than two to only show up on the report. See the items in red below, these are the only ones I want to show up. Is there a way to do this if so how?

 

How to only show Grand Totals by row where the Subtotal in the Grand Total column is greater than one?

 

 Your help is greatly appreciated.

 

Thanks,

 

Rose
2 réponses
  1. Rodrigo Rocha
    2 mars 2016, 03:27
    Hi Rose,

     

    Is the Program object related to another object on a Master Detail relationship? If Program is a child in this relationship, you should be able to create a Rollup Summary field on the parent object.

     

    Create a report for Parent Object with Programs and filter by this field where Your_Roll_Up > = 2.

     

    Regards.
Rédiger une réponse...
0/9000