How to use PivotTable to count records in various categories?

[JayUSA]

Hello Everyone,

I have about 15,000 records in a table. Each record has a field (in the column) called Staff Size.

I'm looking for a relatively clean way to run the following report:

Staff Size <5 : 203 records
Staff Size 5-25: 1109 records
Staff Size 26-50: 11949 records
Staff Size: >50: 3456 records

(no the figures don't add up properly -- just a quick example)

I had thought & hoped that I could do this in a pivot table, but for the life of me, I can't figure out how. If someone could provide 15 fairly-specific steps to do that I'd be very grateful.

I am aware, of course, that I can create a new column, and enter a formula that will assign each record to a Staff Size category, and then count the records assigned to each category....

...but, since I have many more similar analyses to run, I was rather hoping that there might be a cleaner, semi-automated way -- perhaps using pivottables.

Any help would surely be appreciated!

Jay

[contaminated]

Hi
take a look here...\
Let me know, if this one is that what u'r lookin for...

[DonkeyOte]

You can only really "Group" when you have consistent intervals between your primary groups...in your case given you have 2 primary groups that span 20 & 25 you can't use Grouping on Staff Size.

If you modified your buckets to say

<5
5-25
26-45
>45

then you could set MIN to be 5 and MAX to be 45 with interval of 20 and that would create 4 buckets accordingly.