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
PivotFieldDataFormat

Index

Indicates the field is shown as the "index.

Declaration

public const PivotFieldDataFormat Index

Field Value

Type
PivotFieldDataFormat

Normal

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

Declaration

public const PivotFieldDataFormat Normal

Field Value

Type
PivotFieldDataFormat

Percent

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

Declaration

public const PivotFieldDataFormat Percent

Field Value

Type
PivotFieldDataFormat

PercentageOfColumn

Indicates the field is shown as the percentage of column.

Declaration

public const PivotFieldDataFormat PercentageOfColumn

Field Value

Type
PivotFieldDataFormat

PercentageOfDifference

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

Declaration

public const PivotFieldDataFormat PercentageOfDifference

Field Value

Type
PivotFieldDataFormat

PercentageOfParent

Indicates Percentage of parent total.

Declaration

public const PivotFieldDataFormat PercentageOfParent

Field Value

Type
PivotFieldDataFormat

PercentageOfParentColumn

Indicates Percentage of parent column total.

Declaration

public const PivotFieldDataFormat PercentageOfParentColumn

Field Value

Type
PivotFieldDataFormat

PercentageOfParentRow

Indicates Percentage of parent row total.

Declaration

public const PivotFieldDataFormat PercentageOfParentRow

Field Value

Type
PivotFieldDataFormat

PercentageOfRow

Indicates the field is shown as the percentage of row.

Declaration

public const PivotFieldDataFormat PercentageOfRow

Field Value

Type
PivotFieldDataFormat

PercentageOfRunningTotal

Indicates Percentage of running total.

Declaration

public const PivotFieldDataFormat PercentageOfRunningTotal

Field Value

Type
PivotFieldDataFormat

PercentageOfTotal

Indicates the field is shown as percentage of total.

Declaration

public const PivotFieldDataFormat PercentageOfTotal

Field Value

Type
PivotFieldDataFormat

RankAscending

Indicates Rank ascending.

Declaration

public const PivotFieldDataFormat RankAscending

Field Value

Type
PivotFieldDataFormat

RankDecending

Indicates Rank descending.

Declaration

public const PivotFieldDataFormat RankDecending

Field Value

Type
PivotFieldDataFormat

RunTotal

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

Declaration

public const PivotFieldDataFormat RunTotal

Field Value

Type
PivotFieldDataFormat