Distinct Count functionality in Pivot Table (not OLAP!)

[Mike Parry]

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

 

[Peo Sjoblom]

No. To get a distinct count you need to have the source data in Excel and
use a help column..
Then apply the pivot..
You could however use a formula that counts the values from the pivot table.
i.e. let's say you want count unique values,
first put the header for the values in the row and then count the values in
the data, then you could use a simple

=COUNTA(A5:A5000)

if you can import the data to an excel table first here's a way of getting a
distinct count

http://tinyurl.com/2ffny

--

Regards,

Peo Sjoblom

Is there any way to get distinct counts in a pivot table that uses a a SQL

Server table (not a cube) as it's source?