Pivot Tables - Unique items

  • Thread starter Thread starter Sander
  • Start date Start date
S

Sander

Hello,

I run into a situation i dont know how to solve. The source table looks like
this;

WKSNAME,OS,APPLICATION
WKS0001,XP,Excel
WKS0001,XP,Word
WKS0001,XP,Powerpoint
WKS0002,Vista,Word
WKS0002,Vista,Excel
WKS0003,XP,Outlook

I'd like to count the number of XP workstations by using a pivot table.
like this:
OS "count of WKSNAME"
XP 2
Vista 1

The problem i run into is that it counts the nummer of rows (resulting in 4
XP workstations) where i want to count the Unique rows.
Filtering the source data doenst give the desired result, i cant modify the
source data either.

Is it possible to filter for unique rows in a pivot table?

thanks in advance,
Sander
Amsterdam
 
Back
Top