Edit

Share via

ExcelScript.Subtotals interface

Package:
ExcelScript

Subtotals for the Pivot Field.

Properties

automatic

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

Average
count

Count
countNumbers

CountNumbers
max

Max
min

Min
product

Product
standardDeviation

StandardDeviation
standardDeviationP

StandardDeviationP
sum

Sum
variance

Variance
varianceP

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

average

Average

average?: boolean;

Property Value

boolean

count

Count

count?: boolean;

Property Value

boolean

countNumbers

CountNumbers

countNumbers?: boolean;

Property Value

boolean

max

Max

max?: boolean;

Property Value

boolean

min

Min

min?: boolean;

Property Value

boolean

product

Product

product?: boolean;

Property Value

boolean

standardDeviation

StandardDeviation

standardDeviation?: boolean;

Property Value

boolean

standardDeviationP

StandardDeviationP

standardDeviationP?: boolean;

Property Value

boolean

sum

Sum

sum?: boolean;

Property Value

boolean

variance

Variance

variance?: boolean;

Property Value

boolean

varianceP

VarianceP

varianceP?: boolean;

Property Value

boolean