Excel.Subtotals interface

Package:

excel

Subtotals for the Pivot Field.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

automatic	If Automatic is set to true, then all other values will be ignored when setting the Subtotals.
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.

automatic?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

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