Class PivotFieldDataFormat

Represents the data formats for a field in the PivotTable

Inheritance
System.Object
PivotFieldDataFormat
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public sealed class PivotFieldDataFormat : Enum

Fields

Difference

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

Declaration
public const PivotFieldDataFormat Difference
Field Value
Type Description
PivotFieldDataFormat

Index

Indicates the field is shown as the "index.

Declaration
public const PivotFieldDataFormat Index
Field Value
Type Description
PivotFieldDataFormat

Normal

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

Declaration
public const PivotFieldDataFormat Normal
Field Value
Type Description
PivotFieldDataFormat

Percent

Indicates the field is show as the "percentage of".

Declaration
public const PivotFieldDataFormat Percent
Field Value
Type Description
PivotFieldDataFormat

PercentageOfColumn

Indicates the field is shown as the percentage of column.

Declaration
public const PivotFieldDataFormat PercentageOfColumn
Field Value
Type Description
PivotFieldDataFormat

PercentageOfDifference

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

Declaration
public const PivotFieldDataFormat PercentageOfDifference
Field Value
Type Description
PivotFieldDataFormat

PercentageOfParent

Indicates Percentage of parent total.

Declaration
public const PivotFieldDataFormat PercentageOfParent
Field Value
Type Description
PivotFieldDataFormat

PercentageOfParentColumn

Indicates Percentage of parent column total.

Declaration
public const PivotFieldDataFormat PercentageOfParentColumn
Field Value
Type Description
PivotFieldDataFormat

PercentageOfParentRow

Indicates Percentage of parent row total.

Declaration
public const PivotFieldDataFormat PercentageOfParentRow
Field Value
Type Description
PivotFieldDataFormat

PercentageOfRow

Indicates the field is shown as the percentage of row.

Declaration
public const PivotFieldDataFormat PercentageOfRow
Field Value
Type Description
PivotFieldDataFormat

PercentageOfRunningTotal

Indicates Percentage of running total.

Declaration
public const PivotFieldDataFormat PercentageOfRunningTotal
Field Value
Type Description
PivotFieldDataFormat

PercentageOfTotal

Indicates the field is shown as percentage of total.

Declaration
public const PivotFieldDataFormat PercentageOfTotal
Field Value
Type Description
PivotFieldDataFormat

RankAscending

Indicates Rank ascending.

Declaration
public const PivotFieldDataFormat RankAscending
Field Value
Type Description
PivotFieldDataFormat

RankDecending

Indicates Rank descending.

Declaration
public const PivotFieldDataFormat RankDecending
Field Value
Type Description
PivotFieldDataFormat

RunTotal

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

Declaration
public const PivotFieldDataFormat RunTotal
Field Value
Type Description
PivotFieldDataFormat

value__

Declaration
public int value__
Field Value
Type Description
System.Int32