Class PivotItemType

This simple type defines the pivot type for a pivotItem.

Inheritance
System.Object
PivotItemType
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public sealed class PivotItemType : Enum

Fields

Average

Represents the Average.

Declaration
public const PivotItemType Average
Field Value
Type Description
PivotItemType

Blank

Represent the Blank line in the pivot Table.

Declaration
public const PivotItemType Blank
Field Value
Type Description
PivotItemType

Count

Represent the count aggregate functions.

Declaration
public const PivotItemType Count
Field Value
Type Description
PivotItemType

CountA

Represent the count number aggregate functions.

Declaration
public const PivotItemType CountA
Field Value
Type Description
PivotItemType

Data

Represent the data

Declaration
public const PivotItemType Data
Field Value
Type Description
PivotItemType

Default

Represent the default type of Pivot Table. (total aggregate is default)

Declaration
public const PivotItemType Default
Field Value
Type Description
PivotItemType

GrandTotal

Represent the grand total.

Declaration
public const PivotItemType GrandTotal
Field Value
Type Description
PivotItemType

Max

Represent the maximum aggregate function.

Declaration
public const PivotItemType Max
Field Value
Type Description
PivotItemType

Min

Represent the minimum aggregate function.

Declaration
public const PivotItemType Min
Field Value
Type Description
PivotItemType

Product

Represent the product functions.

Declaration
public const PivotItemType Product
Field Value
Type Description
PivotItemType

StdDev

Represents the "standard deviation" aggregate function.

Declaration
public const PivotItemType StdDev
Field Value
Type Description
PivotItemType

StdDevP

Represents the "standard deviation population" aggregate function.

Declaration
public const PivotItemType StdDevP
Field Value
Type Description
PivotItemType

Sum

Represents the "sum" aggregate value.

Declaration
public const PivotItemType Sum
Field Value
Type Description
PivotItemType

value__

Declaration
public int value__
Field Value
Type Description
System.Int32

Var

Represents the "variance" aggregate value.

Declaration
public const PivotItemType Var
Field Value
Type Description
PivotItemType

VarP

Represents the "variance population" aggregate value.

Declaration
public const PivotItemType VarP
Field Value
Type Description
PivotItemType

Extension Methods