DxPivotGridField.GroupInterval Property

Specifies how the values of the current column or row field are combined into groups.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v21.1.dll

Declaration

[Parameter]
[DefaultValue(PivotGridGroupInterval.NotSet)]
public PivotGridGroupInterval GroupInterval { get; set; }

Property Value

Type Default Description
PivotGridGroupInterval

NotSet

A PivotGridGroupInterval value that specifies how the values of the current field are combined into groups.

Available values:

Name Description
NotSet

Unique field values are displayed as is.

Year

This option is in effect only for fields that store date/time values.
Field values are grouped by the year. Examples: 2003, 2004, 2005.

Quarter

This option is in effect only for fields that store date/time values.
Field values are grouped by the quarterly intervals of the year. Each quarter includes three months. Examples: 1, 2, 3, and 4.

Month

This option is in effect only for fields that store date/time values.
Field values are grouped by the month part. Examples: January, February, March (the actual names of the months are determined by the current culture).

Remarks

The control doesn’t group the values of column and row fields by default and displays all their unique values. You can use the GroupInterval property to combine values of these fields into groups.

For instance, you can set the GroupInterval property to Year for a field that displays date/time values. The field combines values belonging to the same year and displays them grouped by year.

Use the HeaderTemplate property to specify the template used to display the field’s header.

The following code snippet shows how to set a group interval:

<DxPivotGrid Data="@GridData">
    <DxPivotGridField Field="@nameof(SaleInfo.Date)" GroupInterval="PivotGridGroupInterval.Year" Area="PivotGridFieldArea.Column" Caption="Year"></DxPivotGridField>
    <DxPivotGridField Field="@nameof(SaleInfo.Date)" GroupInterval="PivotGridGroupInterval.Quarter" Area="PivotGridFieldArea.Column" Caption="Quarter">
        <HeaderTemplate>@string.Format("Q{0}", context)</HeaderTemplate>
    </DxPivotGridField>
</DxPivotGrid>

You can bind multiple DxPivotGridField objects to the same field in the underlying data source. These fields can have different values for their GroupInterval property. In this case, each field groups the same data in its own way.

See Also