Introduced in build 8.3
Description
Sets the ShowValueAs
properties of a PivotTable.
C#
vb.net
Parameters
showValueAs
The type of ShowValueAs described by ShowValueAsType.baseField
The base field for comparisons.baseItemIndex
The index of the base item for comparisonsExamples
C#
vb.net
Remarks
This property cannot be set on ValuesLabels. You can check if a PivotField is calculated field with the IsValuesLabel Property
This is the same as going to Value Field Settings > Show values as.
When calling SetShowValueAs()
, certain ShowValueAsTypes
use a source field as a base field and an index for one of the values in the data source column associated with the source field. The base field and value specified by the base item index are used to compute the values shown in the PivotTable.
Use ShowValueAs.BaseItemNext
and ShowValueAs.BaseItemPrevious
to specify Next or Previous.