I'm working on a pivot table where one of the columns has 24 possible answers; however, the answers actually used in the source varies. The problem is that my filter list only shows answers that have been used in the filter source (which changes frequently). Basically, to simplify, possible answers for the source could be 1, 2, 3, 4 - I want the corresponding pivot table to show only 3 & 4; however, upon update, only 1 and 2 was given and I can no have 3 and 4 on my filter list. I realize this creates an empty pivot table, but the idea is to have 3 & 4 pre-selected so that, if that answer should be there upon refresh, the table will show those entries, and if not, then the table is empty but the filter remains for use in the next update.
I hope that makes sense. I have pictures of my pivot and its source attached. My pivot is currently filtered to show "Occupational Therapy" and "Physical Therapy". I want to be able to have the filter also selected for "Speech Therapy", "Music Therapy", etc., as these answers could populate and should be part of the schedule. However, I don't want the person viewing it to ever have to change the filters, just use a refresh macro that I put on the sheet.
Help, please!
Pivot.PNGSource.PNG
Bookmarks