RadPivotGrid supports three types of grouping by ranges for its row and column fields: date time, numeric and custom.
DateTime range grouping. RadPivotGrid can combine ranges of date time row/column groups into the following time spans: Year, Quarter, Moth, Day. In order to switch on this feature, just set the GroupInterval property of the row/column field to the corresponding value.
Numeric grouping: RadPivotGrid has the capability to aggregate numeric row/column groups into custom numeric ranges. For any field that needs to combine its groups into numeric ranges, the GroupInterval property should be set to Numeric whereas the GroupIntervalNumericRange should be give the numeric span of the interval. The latter accepts double values.
Custom grouping: RadPivotGrid also provides the flexibility to implement a custom way of grouping any row/column field group values. The approach to custom grouping is programmatic and includes the creation of a new pivot grid field class that should inherit the PivotGridColumnField (for column fields) or the PivotGridRowField (for row fields) class. In the child class the GroupDescription property should be overridden to return an instance of a custom GroupDescription class. The latter must inherit the PropertyGroupDescription class and override the GroupNameFromItem method where the custom grouping logic is to be implemented.