Hi everyone, I think this is a quite common issue, but I'd like to know if there is a smarter solution then the ones we thought about.
We know that it is not possible to hide or show a pivot table column simply setting something on its properties (ticking off flags, etc ... ); so we developed two different solution.
Solution #1
Using a macro to set columns width and making it to run after reload.
Solution #2
Replacing each expression with a variable containing its formula and "calling" these variables when defining a new expression. This leads to independence of indicators that can now be enabled/disabled freely.
Is there a smarter solution?
Thanks.