 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / January 2006How to calculate distinct count per group?
I have Department group and want to count how many distinctive customers we have in each of them: I placed this formula in group footer :=countDistinct(Fields!Customers.Value,"Department") but it shows me total number of customers in each row. Oleg Hope u followed the following procedure: 1. Group on Department. 2. CountDistinct(Fields!Customers.Value, "<group name>") NOTE: <group name> is the name of the group not the field on which grouping is done. Regards, Saras |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.