PivotFieldDataDisplayFormat
PivotFieldDataDisplayFormat enumeration
Represents data display format in the PivotTable data field.
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. |