PivotFieldDataDisplayFormat

PivotFieldDataDisplayFormat enumeration

Represents data display format in the PivotTable data field.

Values

NameValueDescription
Normal0Represents normal display format.
DifferenceFrom1Represents difference from display format.
PercentageOf2Represents percentage of display format.
PercentageDifferenceFrom3Represents percentage difference from display format.
RunningTotalIn4Represents running total in display format.
PercentageOfRow5Represents percentage of row display format.
PercentageOfColumn6Represents percentage of column display format.
PercentageOfTotal7Represents percentage of total display format.
Index8Represents index display format.
PercentageOfParentRowTotal9Represents percentage of parent row total display format.
PercentageOfParentColumnTotal10Represents percentage of parent column total display format.
PercentageOfParentTotal11Represents percentage of parent total display format.
PercentageOfRunningTotalIn12Represents percentage of running total in display format.
RankSmallestToLargest13Represents smallest to largest display format.
RankLargestToSmallest14Represents largest to smallest display format.