PivotFieldDisplayFormat Enum
Represents a data PivotField display format.
Fields
Difference | The difference from the value of the Base item in the Base field. |
Index | Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)). |
Normal | No calculation. |
Percent | Percentage of the value of the Base item in the Base field. |
PercentageOfColumn | Percentage of the total for the column or series. |
PercentageOfDifference | Percentage difference from the value of the Base item in the Base field. |
PercentageOfParent | Percentage of the total of the specified parent Base field. |
PercentageOfParentColumn | Percentage of the total of the parent column. |
PercentageOfParentRow | Percentage of the total of the parent row. |
PercentageOfRow | Percentage of the total for the row or category. |
PercentageOfRunningTotal | Rank largest to smallest. |
PercentageOfTotal | Percentage of the grand total of all the data or data points in the report. |
RankAscending | Rank smallest to largest. |
RankDecending | Rank largest to smallest. |
RunTotal | Data for successive items in the Base field as a running total. |