Count/Frequency in Pivot Table
 

I'm assuming that you have a list of the sales people
somewhere in the file.
beside each sale person's name enter
=COUNTIF(Range,"sale person's name")

-----Original Message-----
I need to count or ascertain the frequency of a field.
The pivot table contains a Region, Country, Sales Team,
Sales Person, Client, Product. I need to count the number
of Sales Persons, a simple count on the pivot table
doesn't help because it counts the number of rows and not
the frequency, the number of sales persons. E.g. I have
know I have 75 sales persons but 20000 records my grand
total of sales persons should be 75. Any help on how to
calculate the actual number of Sales Persons would be
great.

TIA
KM
.