Distinct Count functionality in Pivot Table (not OLAP!)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Mike Parry said:
Is there any way to get distinct counts in a pivot table that uses a a SQL
Click to expand...
Server table (not a cube) as it's source?
 
Back
Top