Trigger Pivotgrid Actions via API? (Custom Configurator)

[Jens]

Dear Telerik team,

is it possible to trigger pivotgrid actions via an API?
especially:
- to add dimensions/members or rows or columns (and remove them also)
- to filter dimensions (and to change or reset existing filters)

We need to implement an own custom configurator based on our needs and based on the usability of the
surrounding platform.

Thanks for any suggestions.
Jens

[Georgi Krustev]

Hello Jens,

Did you have a chance to the PivotDataSource API? It has columns, rows, measures and etc methods. It inherits from DataSource, hence it also has filter method.

Check the documentation and let me know if something is not clear.

Regards,
Georgi Krustev
Telerik

 

 

[Jens]

Hi Georgi,
yes I know the pivotdatasource.
I allready used it to setup the pivotgrid with inital data and initial structures.
But can you give a short example on how to use it to trigger a change (e.g. add an additional dimension to the rows).
Thanks
Jens

[Oscar]

Hello Jens.

You can use this to add a new column to the grid:
$("#grid").data("kendoPivotGrid").columnsTarget.add("New column name");

To remove:
$("#grid").data("kendoPivotGrid").columnsTarget.remove("New column name");

And the same would apply for new row fields and measure fields by changing columnsTarget to rowsTarget or measuresTarget.

[Georgi Krustev]

Hi Jens,

When I pointed you to the columns, rows, measures links, I've meant the methods and not the configuration options. Using the methods you can change the columns, rows, measures and etc. Here is a demo that demonstrates how to add dimension to the column axis.

Regards,
Georgi Krustev
Telerik