A pivot table won't count unique values, but there's a workaround here,
if you're using an Excel list as the source:

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


j_cavanagh wrote:
I have a PivotTable that contains a list of buyers, their suppliers, and part
numbers. When I move the buyer and the supplier to the rows and put the
suppliers also into the data area, I get a count of the parts for each
supplier. I assume this is because the PivotTable is counting how many
records contain that buyer,that supplier and the parts related to that
supplier. Is there a way to only count the number of suppliers?

Thank you.


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