Microsoft Office Tutorials and References
In Depth Information
Figure 20-30. Calculation = xlPercentOfColumn
The code for Figure 20-30 is:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Sale").Calculation = xlPercentOfColumn
Figure 20-30. Calculation = xlPercentOfColumn
The code for Figure 20-31 is:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Sale").Calculation = xlPercentOfTotal
Figure 20-31. Calculation = xlPercentOfTotal
 
 
 
 
Search JabSto ::




Custom Search