Try it!
PivotTables are a great way to summarize, analyze, explore, and present your data. You can even group the data in a PivotTable to enhance the layout and format of your PivotTable reports.
Group data
-
In the PivotTable, right-click a value and select Group.
-
In the Grouping box, select the 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 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.