How do i sort and count data into categories using a pivot table?

M

munchkin

Let's say i have this data to analyze:

Company #of employees State Industry

aaa 326 CA Industry A
bbb 1020 CA Industry C
ccc 575 NY Industry D
ddd 12000 VT Industry C

I would like to create a pivot table that summaries data this way:

# of employees
0-100 0
100-1000 2
1000-10000 1
10000-100000 1

or sort and count by brackets of 50 (# of employees):

0-50 0
50-100 0
100-150 0
etc..

Does anyone know how to do this with pivot tables? I know this can be done
because i've seen it done but can't remember how!!!! : (
 
M

munchkin

Thanks for your reply.

Problem is when i right click anywhere on the pivot table, all i have as
option is "group and show detail" and then if i click on "group", it cannot
group the selection. Am i clicking in the wrong place? (i tried clicking just
about everywhere on the pivot table)..
by the way i have Excel 2003..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide "Show details" when right click on data field in Pivot Table 0
Sort Data Items in Pivot Table 8
I'm trying to do a "count" function at the end of a dynamic pivot table 0
How to sort data in data area in a pivot table 2
How do I sort pivot table data by subtotals? 2
Percentage of a "sum of" amount in a different field of a pivot re 2
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
How do i gennerate a field containing the cummulative in a query? 1

Top