I'm not sure how to word my request, other than showing what I want to accomplish usinf an example (see attached Excel spreadsheet with data). My data consists of 2 columns, year and site. If I filter on the year, I do not want the Grand Total for that specific year rather I want all the Grand Total for all years in which a specific site appears. I've attached the spreadsheet that contains the data. I appreciate your consideration of my question.



(My examples containing tables did not display in text. Examples are provided in attached excel file.)

Attached Files

Manipulate data in pivot table.xlsx (16.4 KB, 10 views)