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
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Scripts