Pivot Table Grouping Question

Copper Contributor

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

@duncanush 

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.

S0406.png