ShowValueAs.ShowValueAsType

Description

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

C#

vb.net

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

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.