4 Replies Latest reply on Oct 30, 2012 1:09 AM by Craig Dewar

    automate the hiding of prior period for  % difference table calcs

    Craig Dewar

      I am doing a table calc to compare % Diff Q on Q.


      I have the view filtered to previous 2 Q. 


      This produces a viz with 2 columns, Q2and Q3.  Q2 is blank (i.e. no Q1 to compare against), and Q3 contains the % diff bar.


      I know I can hide the Q2 column with a right mouse click and 'Hide'.  Which works fine - until the next quarter comes along.


      Currently, I have to open each one of my workbooks, open up every view with QonQ % diff, and hide Q3 to get ride of the big fat blank column.


      Is there anyway I can automate the 'hiding' of a value in the comparison column?