Thread: [Solved] Filtering (advanced?) in Pivot Table
View Single Post
 
Old 01-15-2015, 12:35 PM
canajun canajun is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Dec 2014
Posts: 10
canajun is on a distinguished road
Lightbulb Filtering (advanced?) in Pivot Table
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
File Type: xlsx Manipulate data in pivot table.xlsx (16.4 KB, 10 views)
Last edited by canajun; 01-15-2015 at 12:41 PM. Reason: Examples did not appear correctly
Reply With Quote