GrapeCity.Documents.Excel.SubtotalType

Enum SubtotalType

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the type of subtotal for the specified pivot field.

[Flags]
public enum SubtotalType

Fields

Automatic = 1

Specifies that the subtotal type is the same as the value of PivotDataConsolidationFunction. If Automatic is used, all other subtotals should be removed.

Average = 8

Specifies the average.

Count = 4

Specifies the number of values.

CountNums = 128

Specifies the number of numeric values.

Max = 16

Specifies the maximum.

Min = 32

Specifies the minimum.

None = 0

Specifies no subtotal is used.

Product = 64

Specifies the product.

StdDev = 256

Specifies StdDev.

StdDevP = 512

Specifies StdDevP.

Sum = 2

Specifies sum.

Var = 1024

Specifies Var.

VarP = 2048

Specifies VarP.