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 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: