3

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?

Improve this question
1
  • 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, 2013 at 11:50

1 Answer 1

Reset to default
3

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

Improve this answer
1
  • 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, 2017 at 15:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .