The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotFieldGroupByType Enum

Lists values used to specify how items of a row or column field are combined into groups.

Namespace: DevExpress.Spreadsheet

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

Declaration

[Flags]
public enum PivotFieldGroupByType
<Flags>
Public Enum PivotFieldGroupByType
[Flags]
public enum PivotFieldGroupByType
<Flags>
Public Enum PivotFieldGroupByType

Members

Name Description
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.

Hours

Groups items in the date or time field by hours, 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.

Months

Groups items in the date or time field by months.

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.

Quarters

Groups items in the date or time field by quarters.

Seconds

Groups items in the date or time field by seconds, regardless of the date to which the current date/time value belongs.

Years

Groups items in the date or time field by years.

Remarks

To group items in a specific PivotTable field that stores date/time or numeric values, use the PivotField.GroupItems method with the appropriate PivotFieldGroupByType enumeration value(s) passed as a parameter.

See Also