Microsoft Office Tutorials and References
In Depth Information
20.7.15 Subtotals Method
20.7.15 Subtotals Method
This method returns or sets the display of a particular type of subtotal for the specified pivot field.
It is valid for all fields other than data fields. The syntax is:
PivotFieldObject .Subtotals( Index )
where the optional Index parameter indicates the type of subtotal and is a number from Table 20-4 .
Table 20-4. Val ues for the Subtotals Method's Index Parameter
Index
Subtotal Type
1
Automatic
2
Sum
3
Count
4
Average
5
Max
6
Min
7
Product
8
Count Nums
9
StdDev
10
StdDevp
11
Var
12
Varp
For instance, the following code requests a display of subtotals for both Sum and Count:
 
 
Search JabSto ::




Custom Search