Distinct Counts in OLAP

M

Mike Parry

Is there any way to get distinct counts in a pivot table that uses a a SQL Server table (not a cube and not an Excel sheet) as it's source?
 
P

Peter Atherton

-----Original Message-----
Is there any way to get distinct counts in a pivot table
Click to expand...
that uses a a SQL Server table (not a cube and not an
Excel sheet) as it's source?Mike

You can click on the field and change it from sum to count

regards
Peter
 
Top