officefileapi-devexpress-dot-spreadsheet-dot-pivotfield-dot-groupitems-x28-pivotgroupingvalue-pivotgroupingvalue-double-pivotfieldgroupbytype-x29.md
Performs field grouping using the specified grouping properties.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void GroupItems(
PivotGroupingValue startValue,
PivotGroupingValue endValue,
double interval,
PivotFieldGroupByType groupBy
)
Sub GroupItems(
startValue As PivotGroupingValue,
endValue As PivotGroupingValue,
interval As Double,
groupBy As PivotFieldGroupByType
)
| 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.
|
Use this method to apply grouping parameters obtained with the PivotField.GroupingInfo property of another grouped pivot field.
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.
// Group field items from 0 to 150 by 10.
field.GroupItems(0, 150, 10, PivotFieldGroupByType.NumericRanges);
#endregion #GroupFieldByNumericRanges
// Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges);
#endregion #GroupFieldByNumericRanges
// Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges);
#endregion #GroupFieldByNumericRanges
' Group field items from 0 to 150 by 10.
field.GroupItems(0, 150, 10, PivotFieldGroupByType.NumericRanges)
' #End Region ' #GroupFieldByNumericRanges
' Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges)
' #End Region ' #GroupFieldByNumericRanges
' Group field items from 1000 to 4000 by 1000.
field.GroupItems(1000, 4000, 1000, PivotFieldGroupByType.NumericRanges)
#End Region ' #GroupFieldByNumericRanges
See Also