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?
Re: Excel Template - filtering out '(blank)' values
Thank you for your reply.
The ‘blank’ does not come from the data...it comes from the Nprinting table objects. When you ‘mark’ the data on the named sheet, you need to mark the blank line below the data as well, otherwise you only return one value.