Enum PivotFieldDataDisplayFormat

Specifies how values are displayed in the data area of a PivotTable field. Excel UI: "PivotTable Analyze > Field Settings > Show Values As" dropdown.

Namespace: DRIT.Spreadsheet.Pivot
Assembly: DRIT.Spreadsheet.dll
Syntax
public enum PivotFieldDataDisplayFormat
Remarks

This enum mirrors PivotFieldCustomCalculation and is used by DataDisplayFormat.

Fields

Name Description
DifferenceFrom

Display as the difference from a base item.
Index

Display as an index value.
Normal

Normal display (no custom calculation).
PercentageDifferenceFrom

Display as the percentage difference from a base item.
PercentageOf

Display as a percentage of a base item in a base field.
PercentageOfColumnTotal

Display as a percentage of the column total.
PercentageOfGrandTotal

Display as a percentage of the grand total.
PercentageOfParentColumnTotal

Display as a percentage of the parent column item.
PercentageOfParentRowTotal

Display as a percentage of the parent row item.
PercentageOfParentTotal

Display as a percentage of the parent total.
PercentageOfRowTotal

Display as a percentage of the row total.
PercentageOfRunningTotalIn

Display as a percentage running total.
RankLargestToSmallest

Display as rank, largest to smallest.
RankSmallestToLargest

Display as rank, smallest to largest.
RunningTotalIn

Display as a running total.