13 Replies Latest reply: Dec 24, 2016 5:03 AM by Lorna Louw RSS

    Excel Template - filtering out '(blank)' values

    Lorna Louw

      hello guys

       

      PFA

       

      on the template...sheet 'Temp Storage for Pivots'....I have '(blank) ' values. the pivots that I am referring to serve as source for the graphs on the first 2 sheets.

       

      I dont want to display the '(blank ' values on the graphs. now,if this would have been a manual process, I could just manually filter it out, but since these objects will be growing in size (more months to be added etc), I cant do this manually every month.

       

      is there any way I can create a 'static filter' that always filters this out?

       

      thanks!