Percentage Modes

• Aug 01, 2019

Percentage summary display modes are used to display percentages of Total and Grand Total values in data cells.

The following percentage modes are available.

• Percent of the Column Total

  The percentage of the Column Total value is displayed in the cell.

  This mode is specified by the PivotSummaryDisplayType.PercentOfColumn value.

  

• Percent of the Column Grand Total

  The percentage of the Column Grand Total value is displayed in the cell.

  This mode is specified by the PivotSummaryDisplayType.PercentOfColumnGrandTotal value.

  

• Percent of the Row Total

  The percentage of the Row Total value is displayed in the cell.

  This mode is specified by the PivotSummaryDisplayType.PercentOfRow value.

  

• Percent of the Row Grand Total

  The percentage of the Row Grand Total value is displayed in the cell.

  This mode is specified by the PivotSummaryDisplayType.PercentOfRowGrandTotal value.

  

• Percent of the Grand Total

  The percentage of the Grand Total value is displayed in the cell.

  This mode is specified by the PivotSummaryDisplayType.PercentOfGrandTotal value.

  

Note

In percentage summary display modes, values are automatically formatted as percentages. To specify custom formatting settings, use the data field’s PivotGridFieldBase.CellFormat property.