Pivot Tables - Unique items

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
 

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

How to show a count of Unique IDs in a Pivot Table 2
Adding additional column of data to pivot table 1
How do I create ranges/groups in excel in a pivot table? 2
Pivot Table - Max Unique Items 2
Analysing Percentages in Pivot tables in Excel 2003 2
PIVOT - COUNT IF "YES" 1
pivot tables in multiple workbooks using one datasheet? 3
Make a pivot table from an existing pivot table 2

Top