+ Start a Discussion

how do i count unique/distinct values in a column in summary report Here In this below report i need to count the number of distinct/unique values of QuoteIssueDateFormula column,Thanks in advance

In below report for account my total quote count should be 5(unique quote dates in a opportunity ) not 6 ,1,2,3 are from same opp with diff quote date,4 and 5 are with same quote date on single opportunity,6th is for single opp -single quote so my total quote count should be 5 .How to make this unique calculation based on quote date grouped by account.

User-added image
NagendraNagendra (Salesforce Developers) 
Hi Ravikanth,

May I suggest you please check with below link from the success community with a similar discussion which will help you further with the above issue. Hope this helps.

Kindly mark this as solved if it's resolved.

The power one will not work here as i need to get count from unique field value not from unique record id ,Thanks for helping out.
Vishnu ViharVishnu Vihar

Did you find the solution on how to count unique values of each row in summary?