Telerik Forums / KendoReact

Dynamic dataset for pivot grid

1 Answer 79 Views
Matt
Top achievements
Rank 1
Matt asked on 18 Aug 2023, 08:10 PM
I am trying to find out if it is possible to set up a pivot grid with a local dataset that give the use more control over what to pivot. Basically I'd like to get a pivot grid to work more like an excel pivot table where I have a data set and then let the use configure what columns and rows they want out of that data. All examples seem to be using hardcoded column and row axes, is it possible to set up one or two defaults but then let the end user add more rows/columns via the configurator?

1 Answer, 1 is accepted

Sort by
0
Konstantin Dikov
Telerik team
answered on 22 Aug 2023, 10:16 AM

Hello Matt,

The PivotGrid with local binding allows using the configurator for dynamically changing the rows/columns. Please refer to the following example where the fields can be dragged & dropped from the "Columns/Rows" section within the configurator:

Hope this helps.

 

Regards,
Konstantin Dikov
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources!

Matt
Top achievements
Rank 1
commented on 22 Aug 2023, 01:49 PM

Hi Konstantin,

This kind of answers my question, however it still seems like I need to know what columns are in the data, if I am creating a solution for multiple clients I might not know their custom fields, with this solution it looks like I need to know all the properties of the data ahead of time. Is there a truly dynamic way to read a dataset and then create rows/columns form that data? 

Konstantin Dikov
Telerik team
commented on 24 Aug 2023, 08:49 AM

Hi Matt, 

I have to say that there is no automatic way for generating the required collections listed in the "Local Binding" demo:

  • dimensions
  • measures
  • defaultRowAxes
  • defaultColumnAxes
  • defaultMeasureAxes
However, if you can generate them dynamically based on the local data, you can then pass them to the PivotGrid and the Configurator, so that the end users can customize the PivotGrid. 



Asked by
Matt
Top achievements
Rank 1
Answers by
Konstantin Dikov
Telerik team
Share this question
or