I have a dataset with 2 columns, Site and Year. The Sites are labelled 1A, 2D, 3J and so forth. Values from the Sites (such as 1A) are distributed in year 2014, or 2015, or 2016, etc. (many Site values in many years). I want to select sites from year 2015 (1E, 1J) and remove them from subsequent selections (by site or by year) until I choose to return them to the dataset. I've attached my data as well as the pivot table. Thank you!

Attached Files

Manipulate data in pivot table.xlsx (15.2 KB, 11 views)

What about 1Y?

I'm not sure what you mean by this? Do you mean you want them removed from the pivot table result? If so, use the filters on the pivot table column headers.

If you filter out 1E though, it removes the result for this site in 2019. If you filter 2015 from the year, it also filters out 1Y.