officefileapi-devexpress-dot-spreadsheet-8ab82a7f.md
Lists values that specify how items of a row or column field are grouped.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[Flags]
public enum PivotFieldGroupByType
<Flags>
Public Enum PivotFieldGroupByType
| Name | Description |
|---|---|
None |
Indicates that field items are not grouped.
|
| NumericRanges |
Groups items in a numeric field into intervals.
The interval length is defined by the interval parameter of the PivotField.GroupItems method and returned by PivotFieldGroupingInfo.Interval property.
|
| 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 PivotField.GroupItems method and returned by the PivotFieldGroupingInfo.Interval property.
|
| 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.
|
The following properties accept/return PivotFieldGroupByType values:
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.
See Also