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.