PivotShowValuesSetting class

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

The PivotShowValuesSetting type exposes the following members:

Property	Description
calculation_type	Represents how to show values of a data field in the pivot report.
base_field_index	Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
base_item_position_type	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.
base_item_index	Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.