To better understand data dependencies, you can group data in a pivot table using various predefined group modes. To group values of some field, right-click the field in the Data Source view and select a required group mode from the shortcut menu. It will appear as a new sub-field of the selected field and you will be able to add it to a required area in a pivot table.
Values of date and time type can be grouped by years, months, quarters, days, weeks, days, etc. Numeric data can be grouped into numeric ranges, for example 0-9, 10-19, etc. Text data can be grouped by first letter.
To remove grouping, select a required sub-field, and click Delete.
Besides predefined group modes you can create your own group criteria using the Collection Editor dialog box.
To create a custom group mode, do the following steps:
In the Data Source view, right-click a field you want to apply a custom group mode, and select Custom on the shortcut menu.
When the Collection Editor dialog box opens, enter a value to set a range for grouping. The pivot table will group the field values into the specified range and a custom group mode will appear as a new sub-field of the selected field in the Data Source view. To delete a custom group mode, right-click the sub-field and select Remove Group on the menu.