By default, all unique field values of column and row fields are listed along the pivot grid's top and left edges. These values represent headers of the columns and rows - the report's axes.
The Pivot Grid provides the grouping feature, allowing field values to be grouped into categories (ranges). This is useful for representing date/time and numeric data. For instance, values of a column or row field which displays date/time data, can be grouped by years, months, quarters, etc. Numeric values can be grouped into numeric ranges. String values can be grouped by the starting characters.
The following image shows two ASPxPivotGrid controls. The first control displays the original data before it's grouped. The second control groups values of the 'Order Date' column field by years.
Multiple fields in the ASPxPivotGrid control can be bound to the same field in the underlying data source. The values of these fields can be grouped independently. For instance, it's possible to create two fields and bind them to the 'OrderDate' field in the data source. The first field can group data by years, the second field - by quarters, as shown in the image below:
Assume that the ASPxPivotGrid control is bound to a data table that contains an 'OrderDate' field. In the following example, two PivotGridField fields are created and displayed in the Column Header Area, each of them bound to the 'OrderDate' field. The first pivot grid field's values will be grouped by years, the second field's values will be grouped by months. To group data, the PivotGridFieldBase.GroupInterval property is used.