+ Start a Discussion
ravikanth321ravikanth321 

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.

Thanks,
Nagendra
ravikanth321ravikanth321
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.