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

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