Hello,
I have a daily report and a pivot table/chart that is displaying stuff from a source tab that is dynamic.
Every day the amount of rows jumps randomly +1...-1000. I want to expand the Pivot Source Data in advance to 99999 rows to accommodate the future expansion
without re-mapping the source data every morning.
My pivot has a source range - how to tweak it to ignore the empty values from the unoccupied cells in the dynamic source tab?
There are also formulas that are converting dates to weeknum and if they are empty i get zeroes and/or ######## (if formatted as short date) or "-1" if formatted as general.
I tried adding Label Filter to exclude (blank), but it's only a half of the problem - ###/-1 are still there.
Thanks
pivot.jpg
Bookmarks