Microsoft Office Tutorials and References
In Depth Information
Figure 20-36. ShowAllItems = True
On the other hand, the code:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Store Type").ShowAllItems = True
will produce the pivot table shown in Figure 20-36 .
Figure 20-36. ShowAllItems = True
 
 
Search JabSto ::




Custom Search