Enum eSubTotalFunctions¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

Built-in subtotal functions

[Flags]
public enum eSubTotalFunctions

Fields¶

None = 1

None

Count = 2

Count cells that are numbers.

CountA = 4

Count cells that are not empty.

Avg = 8

Average

Default = 16

Default, total

Min = 32

Minimum

Max = 64

Maximum

Product = 128

Product

StdDev = 256

Standard deviation

StdDevP = 512

Standard deviation of a population

Sum = 1024

Summary

Var = 2048

Variation

VarP = 4096

Variation of a population