Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotField.GroupItems(Double, Double, Double) Method

Performs numeric grouping in the current field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

void GroupItems(
    double startValue,
    double endValue,
    double interval
)

#Parameters

Name Type Description
startValue Double

A Double value that is the smallest value to be grouped. If this argument is omitted or null, the smallest value in the field is used.

endValue Double

A Double value that is the largest value to be grouped. If this argument is omitted or null, the largest value in the field is used.

interval Double

A Double value that specifies an interval for each group. If this argument is omitted, the group interval is calculated automatically.

#Example

View Example

Worksheet worksheet = workbook.Worksheets["Report12"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Access the "Usual Hours Worked" field by its name in the collection.
PivotField field = pivotTable.Fields["Sales"];
// Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges);
See Also