I have created a pivot table that reads off of source data that refreshes every day. The pivot table is going to refresh to show the current data. However, I only want to show the data for two of the row tables "data 1" and "data 2". The problem is that sometimes when the data refreshes new data comes in that wasn't in there before and it will be pulled into the pivot table lets call this "data 3" and "Data 4".
I want the macro to refresh the table, and then filter to only show "Data 1" and "data 2" not anything else.
I can't just do .pivotitems("data 4").visible = false because it is unpredictable what "data 3", "data 4", etc. will be so I can't just eliminate it.
Can anyone help?
I want the macro to refresh the table, and then filter to only show "Data 1" and "data 2" not anything else.
I can't just do .pivotitems("data 4").visible = false because it is unpredictable what "data 3", "data 4", etc. will be so I can't just eliminate it.
Can anyone help?
