The ShowValueAs class contains the options for showing the value of a DataField.
ShowValueAs
public sealed class ShowValueAs
Public NotInheritable Class ShowValueAs
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open("template.xlsx"); SortOptions options = wb[0].PivotTables[0].DataFields[0].ShowValueAs;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("template.xlsx") Dim options As SortOptions = wb(0).PivotTables(0).DataFields(0).ShowValueAs;
Name
Description
BaseIndex
BaseField
ShowValueAsType
ValueType
SetShowValueAs()