PivotFieldTop10AutoShowSettings class

PivotFieldTop10AutoShowSettings class

Represents the Top 10 AutoShow settings for a pivot field.

The PivotFieldTop10AutoShowSettings type exposes the following members:

Properties

PropertyDescription
is_auto_showIndicates whether an “Top 10 AutoShow” filter is applied to this field.
is_topIndicates whether the specified PivotTable field is autoshown ascending.
auto_show_countRepresent the number of top or bottom items
that are automatically shown in the specified PivotTable field.
rank_bySpecifies the index of data field for AutoShow ranking.
Represents auto show field index. -1 means PivotField itself.
It should be the index of the data fields.

Remarks

In xls : Implementing top 10 filters in Xls through Top 10 AutoShow In ooxml files: The underlying ooxml file format supports Top10 AutoShow, but Excel 2007 and later user interface only provides access via Top10 filter. If XLS compatibility is not required, it is recommended to use Top10 filter instead.

See Also