Grouping rows or columns

1. Activate the pivot table.
2. Select the labels for the rows or columns that you want to group together (click and drag or Shift+click to select multiple labels).
3. From the menus choose:

   Edit > Group

A group label is automatically inserted. Double-click the group label to edit the label text.

Note: To add rows or columns to an existing group, you must first ungroup the items that are currently in the group. Then you can create a new group that includes the additional items.