PivotFieldGroupByType Enum
Lists values that specify how items of a row or column field are grouped.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
#Members
Name | Description |
---|---|
None
|
Indicates that field items are not grouped. |
Numeric
|
Groups items in a numeric field into intervals. The interval length is defined by the interval parameter of the Pivot |
Seconds
|
Groups items in the date or time field by seconds, regardless of the date to which the current date/time value belongs. |
Minutes
|
Groups items in the date or time field by minutes, regardless of the date to which the current date/time value belongs. |
Hours
|
Groups items in the date or time field by hours, regardless of the date to which the current date/time value belongs. |
Days
|
Groups items in the date or time field by days. The number of days included in each group is defined by the interval parameter of the Pivot |
Months
|
Groups items in the date or time field by months. |
Quarters
|
Groups items in the date or time field by quarters. |
Years
|
Groups items in the date or time field by years. |
#Related API Members
The following properties accept/return PivotFieldGroupByType values:
#Remarks
Pass the PivotFieldGroupByType enumeration value(s) to the PivotField.GroupItems method to group items in a PivotTable field that stores date/time or numeric values.