Hello!

I have a pivot table for which I currently have two report filters.
For ReportFilter1, I have football teams.
For ReportFilter2, I have the players that are in the league.

The thought process behind the pivot table, was that if I filter to a football team then the next filter should be conditional and only show me the players that are on the team selected. However, my ReportFilter2 is showing me ALL players that are in the league and not just the players that are associated with the team selected.

My question, is there a way to make ReportFilter2 ONLY show the values that are associated with ReportFilter1? I know you should be able to accomplish this through VBA and I am cool with that and just need some code that will accomplish this every time ReportFilter1 is clicked. Any ideas?