Subtotal(AggregateEnum,Int32,String,String) Method
In This Topic
Groups rows based on cell contents and calculates aggregate values.
Syntax
Parameters
- aggType
- AggregateEnum value that specifies the type of aggregate to calculate.
- level
- Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree.
- groupOn
- Name column used to detect group breaks.
- totalOn
- Name of the column that contains values to be aggregated (usually numeric).
See Also