.
Introduced in build 8.4
Description
The ShowValueAs class contains the options for showing the value of a DataField. It is equivalent to the Show Values As tab in DataField settings in Excel.
C#
vb.net
Examples
C#
vb.net
Properties
Name |
Description |
|---|---|
| Returns the base field used in calculating the values for a data field that are shown in the PivotTable. | |
| Returns the base item index of a data field in the PivotTable. | |
Returns a constant associated with selecting "Next" as a base item for SetShowValueAs(). |
|
Returns a constant associated with selecting "Previous" as a base item for SetShowValueAs(). |
|
|
The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter. |
|
Returns the type of calculation used to determine the displayed value of a data field. The available types are determined by ShowValueAs.ShowValueAsType. |
Methods
Name |
Description |
|---|---|
Sets the ShowValueAs properties of a PivotTable. |