PivotField.GroupItems(PivotGroupingValue, PivotGroupingValue, Double, PivotFieldGroupByType) Method

Performs field grouping using the specified grouping properties.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void GroupItems(
    PivotGroupingValue startValue,
    PivotGroupingValue endValue,
    double interval,
    PivotFieldGroupByType groupBy
)

VB.NET

Sub GroupItems(
    startValue As PivotGroupingValue,
    endValue As PivotGroupingValue,
    interval As Double,
    groupBy As PivotFieldGroupByType
)

Parameters

Name	Type	Description
startValue	PivotGroupingValue	A PivotGroupingValue object that specifies the starting value.
endValue	PivotGroupingValue	A PivotGroupingValue object that specifies the ending value.
interval	Double	A Double value that specifies the grouping interval for numeric range grouping or the number of days to group by in date range grouping.
groupBy	PivotFieldGroupByType	A PivotFieldGroupByType enumeration value or a combination of values that specifies the grouping.

Remarks

Use this method to apply grouping parameters obtained with the PivotField.GroupingInfo property of another grouped pivot field.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GroupItems(PivotGroupingValue, PivotGroupingValue, Double, PivotFieldGroupByType) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-pivot-table-examples/CS/SpreadsheetDocServerPivotAPI/CodeExamples/PivotFieldGroupingActions.cs#L58

// Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges);
#endregion #GroupFieldByNumericRanges

wpf-spreadsheet-pivot-table-api-examples/CS/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotFieldGroupingActions.cs#L58

// Group field items from 0 to 150 by 10.
field.GroupItems(0, 150, 10, PivotFieldGroupByType.NumericRanges);
#endregion #GroupFieldByNumericRanges

winforms-spreadsheet-pivot-table-api/CS/SpreadsheetPivotTableExamples/CodeExamples/PivotFieldGroupingActions.cs#L58

// Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges);
#endregion #GroupFieldByNumericRanges

VB.NET

spreadsheet-document-api-pivot-table-examples/VB/SpreadsheetDocServerPivotAPI/CodeExamples/PivotFieldGroupingActions.vb#L53

            ' Group field items from 1000 to 4000 by 1000.
            field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges)
'            #End Region ' #GroupFieldByNumericRanges

wpf-spreadsheet-pivot-table-api-examples/VB/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotFieldGroupingActions.vb#L53

            ' Group field items from 0 to 150 by 10.
            field.GroupItems(0, 150, 10, PivotFieldGroupByType.NumericRanges)
'            #End Region ' #GroupFieldByNumericRanges

winforms-spreadsheet-pivot-table-api/VB/SpreadsheetPivotTableExamples/CodeExamples/PivotFieldGroupingActions.vb#L53

            ' Group field items from 1000 to 4000 by 1000.
            field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges)
'            #End Region ' #GroupFieldByNumericRanges