Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable count unique
I have several pivot tables linked to a single database with 12 fields
All database records are unique One pivot table looks at just 2 fields from 12 as per the simplified example below: Field1 Field2 A abc A abc A def B ghi C hij Would like the pivot table to count the unique occurences from Field2 against Field1 The result would be: A 2 B 1 C 1 Any idea how this could be achieved within a pivot table? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable count unique
Ok, not sure if ur using 2007 or pre-2007, but look at subtotals.
I have this in 2007: Field1 Field2 A abc A abc A def B ghi C hij Select the range of data, Click Subtotal. Then, 'At each change in:' Field2 Use Function: Count Add Subtotal to: Field2 Check: Replace current Subtotals Check: Summary below data Click 'OK' -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "David" wrote: I have several pivot tables linked to a single database with 12 fields All database records are unique One pivot table looks at just 2 fields from 12 as per the simplified example below: Field1 Field2 A abc A abc A def B ghi C hij Would like the pivot table to count the unique occurences from Field2 against Field1 The result would be: A 2 B 1 C 1 Any idea how this could be achieved within a pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique dates within each unique ID | Excel Worksheet Functions | |||
PivotTable Row Count | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
Pivottable to count non-zeros | Excel Discussion (Misc queries) | |||
How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) |