🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Is there a way to give end-users the ability to auto-expand all dimensions?

Lee-ann Dunton asked on July 16, 2019

Is there currently an option available to end-users that gives them the ability to expand or collapse all dimensions?
By default, we display the grid with all dimensions collapsed, giving end-users the ability to drill-down into dimensions. However, in some cases, an end-user may want to expand all dimensions. Is there a way for them to do this via the UI without having to manually click and expand each and every dimension record?
I took a look online & could not find any reference to this, but I also couldn’t find anyone asking the same sort of question. The only thing I’ve been able to find is API documentation on setting the defaults (https://www.flexmonster.com/doc/options/#!grid).
Please advise! Thank you.

2 answers

Vera Didenko Vera Didenko Flexmonster July 17, 2019

Thank you for your question.
We would like to confirm that it is possible to expand all dimensions via the expandAllData() API call:


A button can be added to the user interface for this purpose.
Here is a JSFiddle example for illustration.
Also, you can customize the Toolbar and add a custom tab for expanding all the data.
Here is a JSFiddle example for illustration. 
Please see our customizing theToolbar tutorial for reference: https://www.flexmonster.com/doc/customizing-toolbar/
Furthermore, it is possible to add an option to expand all data to the context menu.
Here is a JSFiddle example for illustration. 
More information about how to customize the context menu can be found here: https://www.flexmonster.com/doc/customizing-context-menu/.
Please let us know if everything works fine for you.
You are welcome to contact us in case of questions.
Best Regards,

Lee-ann Dunton July 17, 2019

Thank you!

Please login or Register to Submit Answer