Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count function in pivot table
How to count the number of types under certain group in a pivot table:
Such as one sku occurs twice under one customer, I only need 1 in pivot table, instead of count the numbers of occurrences: 2 |
#2
|
|||
|
|||
A pivot table won't calculate a unique count. You could add a column to
the list, then add that field to the pivot table. There's an example he http://www.contextures.com/xlPivot07.html#Unique Holly wrote: How to count the number of types under certain group in a pivot table: Such as one sku occurs twice under one customer, I only need 1 in pivot table, instead of count the numbers of occurrences: 2 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Count Unique in Pivot Table | Excel Discussion (Misc queries) | |||
count distinct in Pivot table | Excel Discussion (Misc queries) |