Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this image.
Group data
-
In the PivotTable, right-click a value and select Group.
-
In the Grouping box, select Starting at and Ending at checkboxes, and edit the values if needed.
-
Under By, select a time period. For numerical fields, enter a number that specifies the interval for each group.
-
Select OK.
Group selected items
-
Hold Ctrl and select two or more values.
-
Right-click and select Group.
Name a group
-
Select the group.
-
Select Analyze > Field Settings.
-
Change the Custom Name to something you want and select OK.
Ungroup grouped data
-
Right-click any item that is in the group.
-
Select Ungroup.
Source: Microsoft