Grouping data in a PivotTable can assist you with displaying a subset of data to analyse. For instance, you might want to group a monumental list of dates or times (date and time fields in the PivotTable) into quarters and months, similar to this image.
Note: The time grouping feature is new in Excel 2016. With time grouping, relationships across time-related fields are instantly identified and grouped together once you insert rows of time fields to your PivotTables. After being grouped together, you can drag the group to your Pivot Table and commence your analysis.
- In the PivotTable, right-click a value and press Group.
- In the Grouping box, click Starting at and Ending at checkboxes, and change the values, if required.
- Below By, choose a time period. For numerical fields, type a number that elaborates the interval for every group.
- Press OK.
Group selected items
- Hold Ctrl and pick two or greater values.
- Right-click and choose Group.
Name a group
- Press the group.
- Click Analyse > Field Settings.
- Edit the Custom Name to anything you want and press OK.
Ungroup grouped data
- Right-click any item that is in the group.
- Click Ungroup.