G Guest Jan 31, 2004 #1 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?
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 Jan 31, 2004 #2 -----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
-----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
