PivotField.AutoShow Method (Excel)
Displays the number of top or bottom items for a row, page, or column field in the specified PivotTable report.
Syntax
식 .AutoShow(Type, Range, Count, Field)
식 A variable that represents a PivotField object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Type |
필수 |
Long |
Use xlAutomatic to cause the specified PivotTable report to show the items that match the specified criteria. Use xlManual to disable this feature. |
Range |
필수 |
Long |
The location at which to start showing items. Can be either of the following constants: xlTop or xlBottom. |
Count |
필수 |
Long |
The number of items to be shown. |
Field |
필수 |
String |
The name of the base data field. You must specify the unique name (as returned from the SourceName property), and not the displayed name. |
Example
This example shows only the top two companies, based on the sum of sales:
ActiveSheet.PivotTables("Pivot1").PivotFields("Company") _
.AutoShow xlAutomatic, xlTop, 2, "Sum of Sales"