Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 2 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
add comment

Your Answer

 
discard

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.