Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

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

C#
vb.net

Remarks

Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the IsValuesLabel Property

Values

Name

Description

Normal

Indicates that the field is shown as its normal data
type.

Difference

Indicates the field is shown as the "difference from" a
value.

Percent

Indicates the field is show as the "percentage of"

PercentDiff

Indicates the field is shown as the "percentage
difference from" a value.

RunningTotal

Indicates the field is shown as running total in the
table.

PercentRow

Indicates the field is shown as the percentage of row

PercentColumn

Indicates the field is shown as the percentage of
column.

PercentTotal

Indicates the field is shown as percentage of total.

Index

Indicates the field is shown as the index.

  • No labels