PivotShowValuesSetting
Contents
[
Hide
]PivotShowValuesSetting class
Represents the settings about showing values as when the ShowDataAs calculation is in use.
class PivotShowValuesSetting;
Properties
| Property | Type | Description |
|---|---|---|
| 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. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute. |
| baseItemIndex | number | Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. |
calculationType
Represents how to show values of a data field in the pivot report.
calculationType : PivotFieldDataDisplayFormat;
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. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.
baseItemPositionType : PivotItemPositionType;
baseItemIndex
Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.
baseItemIndex : number;