Enum PivotFunction

Namespace

SheetStream

Assembly

SheetStream.dll

Aggregation applied by a pivot data field (AddDataField(string, PivotFunction, string?, string?)).

public enum PivotFunction

Fields

Average = 2

Arithmetic mean.

Count = 1

Number of non-empty values.

CountNumbers = 6

Number of numeric values.

Max = 3

Largest value.

Min = 4

Smallest value.

Product = 5

Product of the values.

StdDev = 7

Sample standard deviation.

StdDevP = 8

Population standard deviation.

Sum = 0

Sum of the values (Excel's default for numeric columns).

Var = 9

Sample variance.

VarP = 10

Population variance.