PivotShowValuesSetting

PivotShowValuesSetting class

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

Methods

Name	Description
getBaseFieldIndex()	Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
getBaseItemIndex()	Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only fo
getBaseItemPositionType()	Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data
getCalculationType()	Represents how to show values of a data field in the pivot report. The value of the property is PivotFieldDataDisplayFor
setBaseFieldIndex()	Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
setBaseItemIndex()	Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only fo
setBaseItemPositionType()	Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data
setCalculationType()	Represents how to show values of a data field in the pivot report. The value of the property is PivotFieldDataDisplayFor

getBaseFieldIndex()

Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.

getBaseItemIndex()

Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.

getBaseItemPositionType()

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. The value of the property is PivotItemPositionType integer constant.PivotItemPositionType

getCalculationType()

Represents how to show values of a data field in the pivot report. The value of the property is PivotFieldDataDisplayFormat integer constant.PivotFieldDataDisplayFormat

setBaseFieldIndex()

Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.

setBaseItemIndex()

Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.

setBaseItemPositionType()

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. The value of the property is PivotItemPositionType integer constant.PivotItemPositionType

setCalculationType()

Represents how to show values of a data field in the pivot report. The value of the property is PivotFieldDataDisplayFormat integer constant.PivotFieldDataDisplayFormat