dreadnaught
Technical User
When I create a pivot table and run the data I get all the information in the filter/head that will allow me to fileter on. If I run the data a week later even though some of the data is not in the data set it still shows up in the filter as a data point. I know I can change the header in the data set, refresh the pivot table and rename the column to make sure I only see that days data in the filter. Is there an easier way to reset that?