Report filters on a multiple range PivotTable

[Drew_]

Hi all.

I have a fairly complicated question. I have 60 sheets with the exact same table with the following headers in the 6th row:

Hole Yards Par Putts U/D Score Result Course Date

Obviously, I am creating a stats tracker for my golf game. Under the Hole column I have the numbers 1-18 and I want to create a Pivot Table on a separate sheet that will calculate my averages for each hole based on the Course I play. In cell H6 of each sheet is a drop down menu that has all the Course names, so each of the 60 sheets allows me to keep stats for each round of golf I play at specific courses. The way I'm thinking about it is to have the Course name as a report filter and whenever I filter the table to a specific course, my averages for each hole for that course will populate. However, when I create a Pivot Table based on multiple consolidation ranges it does not allow me to pick the labels I want, nor does it allow me to apply any report filters.

I hope I've made sense here. If more information is needed or I wasn't clear, please let me know. Thanks

 

[jondavis1987]

The top row of the table your pivot table is pulling from needs to have headings on it. For instance Column H should be Coarse Name. In column H the only thing in there should be the coarse name. Honestly the best way to use a pivot table is to only have it pull data from one sheet. You probably need to restructure all of your data into one table that the pivot table is pulling from. And when i say it needs to be 1 table that the pivot table pulls from, it needs to be an excel table that you insert. That should take care of the filter problem.