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(
  basePvtTbl, 
  PercentagePivotTable.PercentageMode.GrandTotal);
percentPvtTbl.RoundDigits = 0;

It is possible to calculate a percentage of parent row total or parent column total by specifying another percentage mode values:

  • 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(
  basePvtTbl, 
  PercentagePivotTable.PercentageMode.GrandTotal, 0);
  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%