ExcelScript.Subtotals interface
Subtotals for the Pivot Field.
Properties
| automatic | If |
| average | Average |
| count | Count |
| count |
CountNumbers |
| max | Max |
| min | Min |
| product | Product |
| standard |
StandardDeviation |
| standard |
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