6 Replies Latest reply: Nov 16, 2015 8:15 AM by Settu Periyasamy RSS

    how to hide columns in pivot table but still use the expression in them for other columns

    Rhona Corcoran

      I have a pivot table sceenshot attached where I have added in columns at the end that I have used to calculate % of targets.  I use these columns in the background colour of the columns that  show red, amber, green.

       

      my problem is that I need to hide the columns at the end showing the targets ie Target MH6 Column 5c 10% etc.

       

      When I hide them using the conditional view =0 or =False() the background colour wont work for the other columns as the expressions seem to be hidden also.

       

      Any help on how I can hide these last four columns and keep the colour coding.