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