| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique Pivot Table Count
There are instructions here for calculating unique items in a pivot table.
http://www.contextures.com/xlPivot07.html#Unique Andy wrote: I have a few thousand records. Two of my fields are a unique ID (unique to each row) and customer ID (unique to each customer). Within one pivot table (including some filters), I have 194 records I want to be able to show within this same pivot table, not a count of 194 records, but the count of customers (which could be say 160). -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique count in Pivot Table | Excel Worksheet Functions | |||
| Count Unique using Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot table: how to count unique? need help! | Excel Discussion (Misc queries) | |||
| Count Unique in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Unique Count | Excel Worksheet Functions | |||
Hybrid Mode
