PivotShowValuesSetting
PivotShowValuesSetting class
Represents the settings about showing values as when the ShowDataAs calculation is in use.
class PivotShowValuesSetting;
Properties
| Property | Type | Description |
|---|---|---|
| showValuesAs | PivotShowValuesAsType | Gets and sets how to show values of a data field in the pivot report. |
| calculationType | PivotFieldDataDisplayFormat | Represents how to show values of a data field in the pivot report. |
| baseFieldIndex | number | Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use. |
| baseItemPositionType | PivotItemPositionType | Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute. |
| baseFieldName | string | Readonly. Gets caption of the pivot base field. |
| baseItemCaption | string | Readonly. Gets caption of the pivot item in the base field. |
| baseItemIndex | number | Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. |
showValuesAs
Gets and sets how to show values of a data field in the pivot report.
showValuesAs : PivotShowValuesAsType;
calculationType
Represents how to show values of a data field in the pivot report.
calculationType : PivotFieldDataDisplayFormat;
Remarks
NOTE: This property is now obsolete. Instead, please use PivotShowValuesSetting.ShowValuesAs property instead. This method will be removed 12 months later since November 2026. Aspose apologizes for any inconvenience you may have experienced.
baseFieldIndex
Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
baseFieldIndex : number;
baseItemPositionType
Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.
baseItemPositionType : PivotItemPositionType;
Remarks
NOTE: This property is now obsolete. Instead, please use PivotShowValuesSetting.BaseItem property instead. This method will be removed 12 months later since November 2026. Aspose apologizes for any inconvenience you may have experienced.
baseFieldName
Readonly. Gets caption of the pivot base field.
baseFieldName : string;
baseItemCaption
Readonly. Gets caption of the pivot item in the base field.
baseItemCaption : string;
baseItemIndex
Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use.
baseItemIndex : number;
Remarks
PivotShowValuesSetting.PreviousPivotItem (-1) for the preceding item, PivotShowValuesSetting.NextPivotItem (-2) for the succeeding item; non‑negative values denote the ordinal index of a specific pivot item.