PivotFieldDataDisplayFormat enumeration

PivotFieldDataDisplayFormat enumeration

Represents data display format in the PivotTable data field.

The PivotFieldDataDisplayFormat type exposes the following members:

Fields

FieldDescription
NORMALRepresents normal display format.
DIFFERENCE_FROMRepresents difference from display format.
PERCENTAGE_OFRepresents percentage of display format.
PERCENTAGE_DIFFERENCE_FROMRepresents percentage difference from display format.
RUNNING_TOTAL_INRepresents running total in display format.
PERCENTAGE_OF_ROWRepresents percentage of row display format.
PERCENTAGE_OF_COLUMNRepresents percentage of column display format.
PERCENTAGE_OF_TOTALRepresents percentage of total display format.
INDEXRepresents index display format.
PERCENTAGE_OF_PARENT_ROW_TOTALRepresents percentage of parent row total display format.
PERCENTAGE_OF_PARENT_COLUMN_TOTALRepresents percentage of parent column total display format.
PERCENTAGE_OF_PARENT_TOTALRepresents percentage of parent total display format.
PERCENTAGE_OF_RUNNING_TOTAL_INRepresents percentage of running total in display format.
RANK_SMALLEST_TO_LARGESTRepresents smallest to largest display format.
RANK_LARGEST_TO_SMALLESTRepresents largest to smallest display format.

See Also