Skip to end of metadata
Go to start of metadata

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

BaseField

Returns the base field used in calculating the values for a data field that are shown in the PivotTable.

BaseIndex

Returns the base item index of a data field in the PivotTable.

BaseItemNext

Returns a constant associated with selecting "Next" as a base item for SetShowValueAs().

BaseItemPrevious

Returns a constant associated with selecting "Previous" as a base item for SetShowValueAs().

ShowValueAsType

The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter.

ValueType

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

SetShowValueAs()

Sets the ShowValueAs properties of a PivotTable.
  • No labels