Pivot filter Help
 

Is there a way to filter a pivot table field based on a cell range within the
sheet?

I want to filter out all results except whatever is listed in cell a2. this
can be a number or text. the pivot table field list can have as many as 300
options.

Any help is greatly apprechiated.
Peter