GrapeCity.Documents.Excel.PivotFieldDateGroupOptions.GroupBy

GroupBy Property

GroupBy

Gets or sets the date and time units used to create the grouped PivotField.

When multiple units are used, grouping is applied in the standard order from seconds through years. At least one unit is required when grouping is applied.

Declaration

public PivotFieldDateGroupBy GroupBy { get; set; }

Public Property GroupBy As PivotFieldDateGroupBy

Examples

PivotFieldDateGroupOptions options = new PivotFieldDateGroupOptions();
options.GroupBy = PivotFieldDateGroupBy.Months | PivotFieldDateGroupBy.Years;
PivotFieldDateGroupBy groupBy = options.GroupBy;