0 Replies Latest reply: Oct 18, 2010 7:51 AM by Alberto Gugel RSS

    Hiding/showing pivot table columns - smarter solution

    Alberto Gugel

      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.