Excel.Subtotals interface

Subtotals for the Pivot Field.

[ API set: ExcelApi 1.8 ]

Properties

automatic

If Automatic is set to true, then all other values will be ignored when setting the Subtotals.

[ API set: ExcelApi 1.8 ]

average
count
countNumbers
max
min
product
standardDeviation
standardDeviationP
sum
variance
varianceP

Property Details

automatic

If Automatic is set to true, then all other values will be ignored when setting the Subtotals.

[ API set: ExcelApi 1.8 ]

automatic?: boolean;

Property Value

boolean

average

average?: boolean;

Property Value

boolean

count

count?: boolean;

Property Value

boolean

countNumbers

countNumbers?: boolean;

Property Value

boolean

max

max?: boolean;

Property Value

boolean

min

min?: boolean;

Property Value

boolean

product

product?: boolean;

Property Value

boolean

standardDeviation

standardDeviation?: boolean;

Property Value

boolean

standardDeviationP

standardDeviationP?: boolean;

Property Value

boolean

sum

sum?: boolean;

Property Value

boolean

variance

variance?: boolean;

Property Value

boolean

varianceP

varianceP?: boolean;

Property Value

boolean