Microsoft Office Tutorials and References
In Depth Information
Figure 20-24. Illustrating AutoShow
Figure 20-24. Illustrating AutoShow
As you can see, the top sales in Boston are from the company stores, whereas the top sales in the
other cities are in franchise stores.
The same code as the previous but with Type set to xlManual will remove the restrictions and
restore the original pivot table:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Store Type").AutoShow _
xlManual, xlTop, 1, "Sale"
The following properties are associated with AutoShow:
AutoShowCount property
The read-only AutoShowCount property returns the number of items that are
automatically shown in the pivot field (this is the Count parameter of the AutoShow
AutoShowField property
This read-only property returns the name of the data field used to determine which items
are shown (this is the Field parameter of the AutoShow method).
AutoShowRange property
This read-only property returns xlTop or xlBottom . This is the value of the Range
parameter of the AutoShow method.
AutoShowType property
This read-only property returns xlAutomatic if AutoShow is enabled for the pivot field
and xlManual if AutoShow is disabled.
20.7.2 Sorting Pivot Fields
The AutoSort method sets the automatic field-sorting rules for the pivot field. The syntax is:
PivotFieldObject .AutoSort( Order , Field )
Search JabSto ::

Custom Search