PivotFieldDataDisplayFormat

PivotFieldDataDisplayFormat enumeration

Represents data display format in the PivotTable data field.

public enum PivotFieldDataDisplayFormat

Values

Name Value Description
Normal 0 Represents normal display format.
DifferenceFrom 1 Represents difference from display format.
PercentageOf 2 Represents percentage of display format.
PercentageDifferenceFrom 3 Represents percentage difference from display format.
RunningTotalIn 4 Represents running total in display format.
PercentageOfRow 5 Represents percentage of row display format.
PercentageOfColumn 6 Represents percentage of column display format.
PercentageOfTotal 7 Represents percentage of total display format.
Index 8 Represents index display format.
PercentageOfParentRowTotal 9 Represents percentage of parent row total display format.
PercentageOfParentColumnTotal 10 Represents percentage of parent column total display format.
PercentageOfParentTotal 11 Represents percentage of parent total display format.
PercentageOfRunningTotalIn 12 Represents percentage of running total in display format.
RankSmallestToLargest 13 Represents smallest to largest display format.
RankLargestToSmallest 14 Represents largest to smallest display format.

See Also