PivotFieldDataFormat Enumeration

Represents the data formats for a field in the PivotTable

Syntax

'Declaration
 
Public Enum PivotFieldDataFormat 
   Inherits System.Enum

'Usage
 
Dim instance As PivotFieldDataFormat

public enum PivotFieldDataFormat : System.Enum

Members

Member	Description
Difference	Indicates the field is shown as the "difference from" a value.
Index	Indicates the field is shown as the "index.
Normal	Indicates that the field is shown as its normal data type.
Percent	Indicates the field is show as the "percentage of".
PercentageOfColumn	Indicates the field is shown as the percentage of column.
PercentageOfDifference	Indicates the field is shown as the "percentage difference from" a value.
PercentageOfParent	Indicates Percentage of parent total.
PercentageOfParentColumn	Indicates Percentage of parent column total.
PercentageOfParentRow	Indicates Percentage of parent row total.
PercentageOfRow	Indicates the field is shown as the percentage of row.
PercentageOfRunningTotal	Indicates Percentage of running total.
PercentageOfTotal	Indicates the field is shown as percentage of total.
RankAscending	Indicates Rank ascending.
RankDecending	Indicates Rank descending.
RunTotal	Indicates the field is shown as running total in the table.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Syncfusion.XlsIO.PivotFieldDataFormat

AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.52