Back to Devexpress

PivotField.GroupItems(DateTime, DateTime, Int32, PivotFieldGroupByType) Method

officefileapi-devexpress-dot-spreadsheet-dot-pivotfield-dot-groupitems-x28-system-dot-datetime-system-dot-datetime-system-dot-int32-devexpress-dot-spreadsheet-dot-pivotfieldgroupbytype-x29.md

latest2.3 KB
Original Source

PivotField.GroupItems(DateTime, DateTime, Int32, PivotFieldGroupByType) Method

Performs grouping by dates in the specified interval.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void GroupItems(
    DateTime startValue,
    DateTime endValue,
    int interval,
    PivotFieldGroupByType groupBy
)
vb
Sub GroupItems(
    startValue As Date,
    endValue As Date,
    interval As Integer,
    groupBy As PivotFieldGroupByType
)

Parameters

NameTypeDescription
startValueDateTime

A DateTime value that is the start of the time interval to group.

| | endValue | DateTime |

A DateTime value that is the end of the time interval to group.

| | interval | Int32 |

An integer that is the number of days in each group. Applicable if the grouping type is PivotFieldGroupByType.Days.

| | groupBy | PivotFieldGroupByType |

A PivotFieldGroupByType enumeration value or a combination of values which specifies how the pivot field is grouped.

|

See Also

PivotField Interface

PivotField Members

DevExpress.Spreadsheet Namespace