Table of Contents

Enum eItemType

Namespace
OfficeOpenXml.Table.PivotTable
Assembly
EPPlus.dll

The item type for a pivot table field

public enum eItemType

Fields

Avg = 1

The pivot item represents an "average" aggregate function.

Blank = 2

The pivot item represents a blank line.

Count = 3

The pivot item represents custom the "count" aggregate function.

CountA = 4

The pivot item represents custom the "count numbers" aggregate.

Data = 0

The pivot item represents data.

Default = 5

The pivot item represents the default type for this PivotTable. The default pivot item type is the "total" aggregate function.

Grand = 6

The pivot items represents the grand total line.

Max = 7

The pivot item represents the "maximum" aggregate function.

Min = 8

The pivot item represents the "minimum" aggregate function.

Product = 9

The pivot item represents the "product" function.

StdDev = 10

The pivot item represents the "standard deviation" aggregate function.

StdDevP = 11

The pivot item represents the "standard deviation population" aggregate function.

Sum = 12

The pivot item represents the "sum" aggregate value.

Var = 13

The pivot item represents the "variance" aggregate value.

VarP = 14

The pivot item represents the "variance population" aggregate value.