There are instructions here for calculating unique items in a pivot table.

http://www.contextures.com/xlPivot07.html#Unique

Andy wrote:
I have a few thousand records. Two of my fields are a unique ID (unique to
each row) and customer ID (unique to each customer).

Within one pivot table (including some filters), I have 194 records

I want to be able to show within this same pivot table, not a count of 194
records, but the count of customers (which could be say 160).


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com