PivotShowValuesSetting

PivotShowValuesSetting class

Represents the settings about showing values as when the ShowDataAs calculation is in use.

class PivotShowValuesSetting;

Properties

PropertyTypeDescription
showValuesAsPivotShowValuesAsTypeGets and sets how to show values of a data field in the pivot report.
calculationTypePivotFieldDataDisplayFormatRepresents how to show values of a data field in the pivot report.
baseFieldIndexnumberRepresents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
baseItemPositionTypePivotItemPositionTypeRepresents 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.
baseFieldNamestringReadonly. Gets caption of the pivot base field.
baseItemCaptionstringReadonly. Gets caption of the pivot item in the base field.
baseItemIndexnumberRepresents 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.