Can we have a pivot containing different values in drill down

[ICS]

Hi All, 

I am trying to use PivotGrid component and presently using its calculated field functionality, 

So is it possible to have two separate calculations as shown in attached image i.e 

For parent AS its calculated value is based on logic which i can customize and child A and H  value different calculation. 

Kind Regards

Akshat Tandon

Attachment: custom_aggrgartion_in_pivot_1888f72.rar

[Saranya Sivan]

Hi ICS, 

  

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. Please check the below sample and UG. 

  

Sample: https://stackblitz.com/edit/angular-kk4ag1-utbvdd?file=app.component.html 

  

UG: https://ej2.syncfusion.com/angular/documentation/pivotview/aggregation/#aggregatecellinfo 

  

Please let us know if you need any further assistance on this. 

  

Regards, 

Saranya Sivan.