Specifies the type of subtotal to display for a field.
Contained In
Remarks
For a PivotList column or row field, this element contains the string constant Sum or one of the following string constants specifying either no subtotals or subtotals included by the data source: None or Default. The NoRowGrand, NoColumnGrand, and PLSubtotal elements are used for other types of fields.
For a PivotTable report on a worksheet, this element contains one of the following string constants specifying the function: Avg, Count, CountNums, Max, Min, Product, StdDev, StdDevP, Sum, Var, VarP, or one of the following string constants specifying either no subtotals or subtotals included by the data source: None or Default. If this element is not specified, the default value is Default.
See the example in the PivotTable element topic.