Grouping PivotTable Data
You can group PivotTable items to identify different subsets of data. For example, dates can be grouped into months, quarters or years.
- Select the date field in the PivotTable
- Click the PivotTable button on the PivotTable toolbar
- Select Group and Show Detail and then Group from the list
- Specify start and end dates to group and the interval to group by
- Click Ok
The Grouping dialogue box appears.
It is possible to select more than one interval. For example, to group by months and years, click on both intervals.
To group by weeks, select days and enter 7 in the Number of days box.
The PivotTable is grouped as specified. In the example below, months and years was chosen. Notice that years is then added to the field list. The field can be used in further data analysis within the PivotTable.