Class PivotItemType
This simple type defines the pivot type for a pivotItem.
Inheritance
System.Object
PivotItemType
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public sealed class PivotItemType : EnumFields
Average
Represents the Average.
Declaration
public const PivotItemType AverageField Value
| Type |
|---|
| PivotItemType |
Blank
Represent the Blank line in the pivot Table.
Declaration
public const PivotItemType BlankField Value
| Type |
|---|
| PivotItemType |
Count
Represent the count aggregate functions.
Declaration
public const PivotItemType CountField Value
| Type |
|---|
| PivotItemType |
CountA
Represent the count number aggregate functions.
Declaration
public const PivotItemType CountAField Value
| Type |
|---|
| PivotItemType |
Data
Represent the data
Declaration
public const PivotItemType DataField Value
| Type |
|---|
| PivotItemType |
Default
Represent the default type of Pivot Table. (total aggregate is default)
Declaration
public const PivotItemType DefaultField Value
| Type |
|---|
| PivotItemType |
GrandTotal
Represent the grand total.
Declaration
public const PivotItemType GrandTotalField Value
| Type |
|---|
| PivotItemType |
Max
Represent the maximum aggregate function.
Declaration
public const PivotItemType MaxField Value
| Type |
|---|
| PivotItemType |
Min
Represent the minimum aggregate function.
Declaration
public const PivotItemType MinField Value
| Type |
|---|
| PivotItemType |
Product
Represent the product functions.
Declaration
public const PivotItemType ProductField Value
| Type |
|---|
| PivotItemType |
StdDev
Represents the "standard deviation" aggregate function.
Declaration
public const PivotItemType StdDevField Value
| Type |
|---|
| PivotItemType |
StdDevP
Represents the "standard deviation population" aggregate function.
Declaration
public const PivotItemType StdDevPField Value
| Type |
|---|
| PivotItemType |
Sum
Represents the "sum" aggregate value.
Declaration
public const PivotItemType SumField Value
| Type |
|---|
| PivotItemType |
Var
Represents the "variance" aggregate value.
Declaration
public const PivotItemType VarField Value
| Type |
|---|
| PivotItemType |
VarP
Represents the "variance population" aggregate value.
Declaration
public const PivotItemType VarPField Value
| Type |
|---|
| PivotItemType |