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

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

[Flags]
public enum PivotFieldGroupByType

#Members

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.

#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.

See Also