Forum Discussion
Pivot Table Grouping Question
I am making a pivot table as can be seen in the attached screenshot. I am trying to group the cost/price row using the groups $6.00-$7.00, $7.00-$8.00, $8.00-$9.00 and $9.00-$10.00. How would I go about changing the grouping of these rows?
1 Reply
Right-click in any of the amounts.
Select Group... from the context menu.
Enter 6 in the 'Starting at' box, 10 in the 'Ending at' box, and 1 in the 'By' box.
Click OK.
