Is this possible? I only want to use the PivotGrid to display information without any need for aggregation. I've gotten the example grid to look mostly how I want, but the total column and row are impossible to remove without breaking the compiler: https://codesandbox.io/s/sharp-breeze-05feiz?file=/app/main.jsx
Thank you!
1 Answer, 1 is accepted
Hello, Janki,
Currently, disabling the aggregation of the PivotGrid component is not supported. If the requirement is to display data without the total columns I can recommend using the Grid instead:
https://www.telerik.com/kendo-react-ui/components/grid/
I hope this helps.
Regards,
Filip
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Rank 4
Bronze
Iron
Iron
Hi Filip,
Thank you for your help with this!
How would I display a pivoted table in KendoReact Grid without having to manipulate the data greatly? It comes as row-based data but I want to display it in a column-based manner without any total rows or total columns. Would it be possible to pivot the row-based data using built-in Kendo functions and plug that data into the Grid or would it be more involved? At the moment, my easiest path forward (based on how I see it) is to set up a custom table and plug in the data into each cell somewhat manually.
Thank you!
Hi, Janki,
This depends mostly on how you would like the data to be pivoted and displayed in the UI, the easiest way is to use a custom cell and display the pivoted data per your requirements, more information on custom cells can be found in the following article:
https://www.telerik.com/kendo-react-ui/components/grid/cells/#toc-customization
I consulted with the dev team and we have a PivotGrid feature planned for our January 2023 release, which will enable the developer to hide or show the totals available.
Regards,
Filip
Rank 4
Bronze
Iron
Iron