Show pivot table values as percentages PivotData C# examples

This documentation describes usage of PercentagePivotTable (Toolkit component).

Let's assume that you already have IPivotTable instance with some values and need to display these values as percentage. It is possible to get desired result by wrapping original pivot table model with PercentagePivotTable wrapper:

var basePvtTbl = new PivotTable(
  new[]{"product"}, new[]{"country"}, pvtData);
var percentPvtTbl = new PercentagePivotTable(
percentPvtTbl.RoundDigits = 0;

It is possible to calculate a percentage of parent row total or parent column total; the following percentage calculation types are available:

  • PercentagePivotTable.PercentageMode.GrandTotal
  • PercentagePivotTable.PercentageMode.RowTotal
  • PercentagePivotTable.PercentageMode.ColumnTotal

If pivot table has several measures it is possible to specify which measure should be calculated as the percentage with PercentagePivotTable constructor that accepts measure index as a 3rd parameter:

var percentPvtTbl = new PercentagePivotTable(
  PercentagePivotTable.PercentageMode.GrandTotal, 0);
Note: you can apply PercentagePivotTable several times to calculate percentage for specific measures.
  Germany Belgium Totals
Product1 15 17 32
Product2 10 1 11
Totals 25 18 43
  Germany Belgium Totals
Product1 34% 40% 74%
Product2 23% 3% 26%
Totals 58% 42% 100%