Dynamically dimensions and expressions in pivot

[#1]

Hello,

I have a dashboard with 5 pivot tables that appear or disappear pressing different buttons.

This tables are quite heavy, so I need to do something to keep the application as fluid as possible.

I tought to create a single table that changes dimensions and expressions dynamically pressing each button (avoiding to put all the dimensions and expressions in the table and hiding one or another).

Is it possible to do something like that?

Thanks in advance

[rupamjyotidas]

You can use Conditional box for both 'Dimension' and 'Equation'

Please keep in mind if the tables are too heavy, it always good to limit the User to select something before they can view the Pivot.

[#3]

Hi, thanks.

I've already tried to do in that way with all the dimensions and expressions in the table and showing or hiding one or the other at the push of each button. The application was working fine, but I was wondering if it's possible to do the same thing but sending each time the parameters to the pivot without having all the elements already in it.

Any idea?