Grouping Pivot Tables

The resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result.

1. Select a cell or range of cells in the pivot table.

2. Choose Data - Group and Outline - Group.

Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two Grouping dialogue boxes, either for numeric values, or for date values.

The pivot table must be organised in a way that grouping can be applied.

• To remove a grouping, click inside the group, then choose Data - Group and Outline - Ungroup.

Open file with example:

Related Topics

• Pivot Table
• Creating Pivot Tables
• Formatting Pivot Tables
• Filtering Pivot Tables
• Updating Pivot Tables
• Selecting Pivot Table Output Ranges
• Deleting Pivot Tables
• Pivot Chart