Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am building a report on 2 objects with a parent child (MD) relationship. How can i get the count of unique parents when i get the report filtered by some child objects field criteria. There might be more than 1 child record after applying the condition. How can i get a distinct/unique record count of the parent?

share|improve this question
In a Summary report of Master with Child, applying a cross filter should let you filter on child records (further filtering using a subfilter on child records), and grouped by Parent (say Name) should give you unique count of Parent Records ? – techtrekker Feb 14 '13 at 11:50
up vote 3 down vote accepted

Use the Power of One, as mentioned by Salesforce and discussed in this answer.

share|improve this answer
Thank you. Just figured out the same myself :) – Ganesh Feb 14 '13 at 12:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.