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

 public sealed class ShowValueAsType
Public NotInheritable Class ShowValueAsType

CalculatedFields will return ShowValueAsType.Normal. You can check if a PivotField is calculated field with the IsCacluatedField 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.