Different Aggregations for Columns And Rows on same Value field

[Daniel Turkali]

I am trying to sum the vertical (columns) hierarchies and to average the rows (sub total column: HE22 Total)

So far I have managed to get either both rows and columns to use the sum aggregate or to have both and columns to use the average.

The screenshot shows the setting for "avg" -> the screenshot therefore shows incorrect values for the columns! . I would expect the column called "Q02" to display the following : 50Hertz+ Amprion = Germany/2021-04-20 => 4 + 9 = 13 .

Any idea on how to achieve that ?

(maybe with compute columns and listening to events ?)

[Saranya Sivan]

Hi Martin Damgaard Larsen, 

  

The reported requirement cannot be achieved directly but we suggest you to do the aggregation manually. It can be achieved by using AggregateCellInfo event where you can get the raw data and type of each aggregated values to customize your own aggregation.  

  

Meanwhile, we have prepared a sample for your reference which is available in the below link. 

  

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/7z/PivotTable1849168422 

Regards, 

Saranya S.