You need to sign in to do that
Don't have an account?
ravikanth321
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.
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.
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.
- https://success.salesforce.com/answers?id=9063000000048RbAAI
- https://success.salesforce.com/answers?id=9063A0000019aQMQAY
Hope this helps.Kindly mark this as solved if it's resolved.
Thanks,
Nagendra
Did you find the solution on how to count unique values of each row in summary?