Can I pivot data and display a value without applying any aggregation?

[Michael Barcellona]

I would like to pivot the data without applying any aggregation. I would like to display the values exactly as they are. Is that possible... perhaps uisng calculated fields?

[Dinesh Babu Yadav]

Hi Michael, 

 

Thanks for contacting Syncfusion Support. 

 

Based on our analysis, each cell in the pivot table is an aggregated value from group of records. So, we can’t display data without aggregation. But you can achieve your requirement using EJ2 Grid component. Please refer the following demo and document link. 

 

Demo: https://ej2.syncfusion.com/angular/demos/#/material/grid/default 

Document: https://ej2.syncfusion.com/angular/documentation/pivotview/getting-started/?no-cache=1 

 

Please let us know if you need further help on this. 

 

Regards, 

Dinesh Babu Yadav