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