Table of Contents

Enum eSubTotalFunctions

Namespace
OfficeOpenXml.Table.PivotTable
Assembly
EPPlus.dll

Built-in subtotal functions

[Flags]
public enum eSubTotalFunctions

Fields

Avg = 8

Average

Count = 2

Count cells that are numbers.

CountA = 4

Count cells that are not empty.

Default = 16

Default, total

Max = 64

Maximum

Min = 32

Minimum

None = 1

None

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