4 Replies Latest reply: Aug 18, 2015 6:08 PM by sam parker RSS

    Conditional hide column in Pivot table

    Sandeep Movva

      HI

       

      I am working on a financial dashboard where in it has Group Name, Account,Actual ,Budget ,variance column for Period Year to Date and Full year respectively, Now as the data is not available still for Full year I want to Hide Actual Column for Full Year, When am trying to hide Actual by writing false() or 0 in Condition expression it is hiding the entire Actual column ie also for Period & Year to Date, I just want to Hide Actual Column for Full Year, Is this possible,

       

      I searched on line for this and found some macro to hide the column by adjusting width to 0 but couldn't able to understand where to put that code or how to use, Can any one please help me in this

       

      Attaching

       

      Thanks a lot for your help