count function in pivot table

[Guest]

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]

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