PivotFieldTop10AutoShowSettings class
PivotFieldTop10AutoShowSettings class
Represents the Top 10 AutoShow settings for a pivot field.
The PivotFieldTop10AutoShowSettings type exposes the following members:
Properties
| Property | Description |
|---|---|
| is_auto_show | Indicates whether an “Top 10 AutoShow” filter is applied to this field. |
| is_top | Indicates whether the specified PivotTable field is autoshown ascending. |
| auto_show_count | Represent the number of top or bottom items that are automatically shown in the specified PivotTable field. |
| rank_by | Specifies 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
- module
aspose.cells.pivot