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.