I have a list in range AM2:AM22 in a sheet called "FY2015" data.
I want to use this list to set a filter to show only what is in that list in my pivot table
Can someone help?

This is what I have so far:
Dim pi as pivotitem

HTML Code: 

Thanks!