+ 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.