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!!!! : (