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?

  • 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

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

| improve this answer | |
  • Is there a way to do this on a campaign member report counting the Ultimate Parent accounts? Cannot do a cross-filter because some accounts may not have a Parent. – Kris Ryan Aug 17 '17 at 15:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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