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

Question

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

Rodrigo Rocha · Accepted Answer

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.

Rose Farnham · Answer

Thank you for your answer that did solve part of my problem.  However, now I don't think I asked the correct questions.  I will try again.   I want to run a report based on a custom object that has a Master-Detail relationship with Contacts.  I need to have all completed programs with the following criteria:   Program Name:  Dominate Your Market   Start Year:  2016   Start Month: Feb   Status: Completed   Total Active Programs: greater or equal 1   with the above criteria - I need to see the following in the report   Full Name   Program Name:   Start Month   Start Year   Statue   using this criteria   Start Year: 2016   Status: Active   I know that this can be accomplished in a join report but they are on the Professional version of Salesforce.  Any hope of making this happen.   Thanks,   Rose

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

Reports & Dashboards

Aprendizagem relacionada

Mais ajuda