Enum PivotFunction

Namespace

DocToolkit

Assembly

DocToolkit.Xlsx.dll

The aggregation a PivotDataField applies — mirrors OfficeIMO.Excel.ExcelPivotDataFunction's 11 values 1:1, confirmed by Enum.GetNames, so nothing here can drift from what the writer beneath supports.

public enum PivotFunction

Fields

Average = 1

Average of the field's values.

Count = 2

Count of entries, including non-numeric ones.

CountNumbers = 3

Count of numeric entries only.

Maximum = 4

Largest value.

Minimum = 5

Smallest value.

Product = 6

Product of the field's values.

StandardDeviation = 7

Sample standard deviation.

StandardDeviationP = 8

Population standard deviation.

Sum = 0

Sum of the field's values.

Variance = 9

Sample variance.

VarianceP = 10

Population variance.