Enumeration Value

Description

avg (Average)

Indicates the pivot item represents an "average" aggregate function.

blank (Blank Pivot Item)

Indicates the pivot item represents a blank line.

count (Count)

Indicates the pivot item represents custom the "count" aggregate."

countA (CountA)

Indicates the pivot item represents the "count numbers" aggregate function.

data (Data)

Indicate the pivot item represents data.

default (Default)

Indicates the pivot item represents the default type for this PivotTable. The default pivot item type is the "total" aggregate function.

grand (Grand Total Item)

Indicates the pivot items represents the grand total line.

max (Max)

Indicates the pivot item represents the "maximum" aggregate function.

min (Min)

Indicates the pivot item represents the "minimum" aggregate function.

product (Product)

Indicates the pivot item represents the "product" function.

stdDev (stdDev)

Indicates the pivot item represents the "standard deviation" aggregate function.

stdDevP (StdDevP)

Indicates the pivot item represents the "standard deviation population" aggregate function.

sum (Sum)

Indicates the pivot item represents the "sum" aggregate value.

var (Var)

Indicates the pivot item represents the "variance" aggregate value.

varP (VarP)

Indicates the pivot item represents the "variance population" aggregate value.

Referenced By

i@t (§3.10.1.44); item@t (§3.10.1.45)