I’m working on a project to create pivot table dynamically.
The goal is to build a pivot table based on 2 Collections, which is generated by reading some file. The 1st collection defines the column names and type (e.g. double, string, etc.) of the data. The 2nd one contains a list of strings, which represents all the data, so the type of the data is only known at run time.
I'd like to know is it possible to bind the above data structure to the RadPivotGrid.
I've tried to set a Collection of dynamic objects to the ItemsSource by using LocalDataSourceProvider, but it seems the data are not shown in the pivot table.
An example of the dynamic object.
dynamic dObject1 =
dObject1.Value = 1;
Thanks in advance.