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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table accessing data from OLAP cube 0
Pivot Table Data Aggregation 0
Changing Data Source on Multiple Pivot Tables at once 1
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Distinct Count functionality in Pivot Table (not OLAP!) 1
Dealing with a Pivot Table (when I don't want to) 0

Top