Selvamuthukumar Rajulu

Reports: Filter by related record count

Discussion created by Selvamuthukumar Rajulu on Jun 25, 2020
Latest reply on Jun 25, 2020 by Patrick McQueen

Hey Folks,

 

I would like to create a report with a criteria based on related module record's count.  For example, we have Accounts and related Opportunities, each Accounts have "N" number of opportunities related.  Here, am trying to get all Accounts which has more than 10 Opportunities, so my filter criteria is COUNT(Opportunities) > 10.

 

We know that, it can be achieved using Advanced Reports, but still i would like to know is there any way to achieve this using Reports module itself, because want to add this report into Home Dashlets.

 

Any help very much appreciated, thanks in advance.

 

 

 

Regards,

Selva

Outcomes