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 here:

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