Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Pivot Table - Count If | Excel Discussion (Misc queries) | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Count in Pivot Table | Excel Worksheet Functions | |||
Count/Frequency in Pivot Table | Excel Programming |