How do I create ranges/groups in excel in a pivot table?

C

Ciarán

Using the data set below

Product Cost
A 1
B 2
C 2
D 6
E 7


How do I create a pivot table which groups the costs in costs from 0 -
5 and 6 - 10 and counts them
The resulting pivot table would look something like this.

Cost Count
0-5 3
6-10 2

Thanks in advance

Ciarán
 
D

Dave Peterson

You could add another column and use that to categorize your values.

Or you could create the pivottable by making the cost the row field and the
product the data field (count of product).

Then rightclick on the cost field and choose "Group and show detail", then
Group.

And choose a starting point of 1 (and your max value) and a "by:" of 5.
 
Top