Filtering out Pivot Table Items that use an OLAP connection usin

Hello,

I currently am creating a report that lists countries and their performance over monthly periods.

One of the report filters I have put in is 'Affiliate ID', which is a customer tag that I need to filter out.

However, there are thousands of Affiliate IDs, and I need to filter that list down to 8800, which is far too hard to do manually.

I use a data connection to obtain my data, using an OLAP connection, and I was wondering how I could link a list of affiliate IDs I have in a separate sheet to the larger list in the report filters to just include those I need in VBA?

Thank you very much!