Class PivotViewGroupSetting
Inheritance
Namespace: Syncfusion.EJ2.PivotView
Assembly: Syncfusion.EJ2.dll
Syntax
public class PivotViewGroupSetting : EJTagHelperConstructors
PivotViewGroupSetting()
Declaration
public PivotViewGroupSetting()Properties
Caption
It allows to set the caption to custom field that will be used to created from custom group fields in the pivot table.
It is applicable only for custom grouping.
Declaration
public string Caption { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The default value is null |
CustomGroups
It allows to set the custom group information to create custom group fields.
It is applicable only for custom grouping.
Declaration
public List<PivotViewCustomGroup> CustomGroups { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.List<PivotViewCustomGroup> | The default value is null |
EndingAt
It allows to set the start value/date to group fields to the specified range that to be displayed in the pivot table.
Declaration
public string EndingAt { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The default value is null |
GroupInterval
It allows to specify the date group intervals such as years or quarter or months or days or hours or minutes or seconds to group fields based on that in the pivot table. They options are: Years - Defines group field as 'Years' for date type field. Quarters - Defines group field as 'Quarters' for date type field. QuarterYear - Defines group field as 'Quarter Year' for date type field. Months - Defines group field as 'Months' for date type field. Days - Defines group field as 'Days' for date type field. Hours - Defines group field as 'Hours' for date type field. Minutes - Defines group field as 'Minutes' for date type field. Seconds - Defines group field as 'Seconds' for date type field.
Declaration
public object GroupInterval { get; set; }Property Value
| Type | Description |
|---|---|
| System.Object | The default value is null |
Name
It allows to set the specific field name to apply group settings.
Declaration
public string Name { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The default value is null |
RangeInterval
It allows to set the interval range to group field based on the specified range.
It is applicable only of number type grouping.
Declaration
public double RangeInterval { get; set; }Property Value
| Type | Description |
|---|---|
| System.Double | The default value is null |
StartingAt
It allows to set the start value/date to group fields from the specified range that to be displayed in the pivot table.
Declaration
public string StartingAt { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The default value is null |
Type
It allows to set the type as date or number or custom to the specified field for apply grouping. The types are: Date - Defines group type as 'Date' for date type field Number - Defines group type as 'Number' for numeric type field. Custom - Defines group type as 'Custom' for custom group field.
Declaration
public GroupType Type { get; set; }Property Value
| Type | Description |
|---|---|
| GroupType | The default value is GroupType.Date |