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

  • Thread starter Thread starter Ciarán
  • Start date Start date
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
 
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.
 
Back
Top