Tag

PivotGridField.GroupIntervalNumericRange Property

Gets or sets the length of intervals into which field values are grouped. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v20.1.dll

Declaration

public int GroupIntervalNumericRange { get; set; }
Public Property GroupIntervalNumericRange As Integer

Property Value

Type Description
Int32

An integer value which specifies the length of intervals into which field values are grouped.

Remarks

The values of column and row field can be grouped into intervals. You can select the required group mode via the PivotGridField.GroupInterval property.

The GroupIntervalNumericRange property is in effect if the PivotGridField.GroupInterval property is set to FieldGroupInterval.Numeric, FieldGroupInterval.YearAge, FieldGroupInterval.MonthAge, FieldGroupInterval.WeekAge or FieldGroupInterval.DayAge. In these modes, the GroupIntervalNumericRange property determines the length of group intervals.

For instance, to group numeric values into intervals, set the PivotGridField.GroupInterval property to FieldGroupInterval.Numeric. The GroupIntervalNumericRange property is set to 10 by default. So, the numeric values will be combined into the following intervals: 0-9, 10-19, 20-29, etc.

To customize group field values, handle the PivotGridControl.CustomGroupInterval event.

See Also