Aspose::Cells::Pivot::PivotField::Top10AutoShow method
Contents
[
Hide
]PivotField::Top10AutoShow method
Configures Top10 AutoShow settings for this pivot field.
void Aspose::Cells::Pivot::PivotField::Top10AutoShow(bool isAutoShow, bool isTop, int32_t count, int32_t rankBy)
| Parameter | Type | Description |
|---|---|---|
| isAutoShow | bool | true to enable AutoShow; false to disable. |
| isTop | bool | If true, shows top items; false shows bottom items. |
| count | int32_t | Number of top/bottom items to display. |
| rankBy | int32_t | Index of data field used for ranking. Use -1 to rank by pivot item’s own values. |
Remarks
This method configures the PivotFieldTop10AutoShowSettings.
XLS binary format: AutoShow (Top10) is the native and only supported option.
XLSX (OpenXML): The underlying file format supports Top10 AutoShow, but Excel 2007 and later user interface only exposes this via Top10 filter. If XLS compatibility is not required, it is recommended to use Top10 filter instead.
See Also
- Class Vector
- Class PivotField
- Namespace Aspose::Cells::Pivot
- Library Aspose.Cells for C++
