Andrew has attended:
Excel VBA Intro Intermediate course
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!
RE: Filtering out Pivot Table Items that use an OLAP connection
Hello Andrew
Thank you for your post, and this is something we may be able to help you with.
If you can send through some sample files detailing what you are trying to achieve.
We will then review and confirm if we can provide a solution, scope of work and related costs.
If you wish to pursue this please let us know!
Regards
Jacob
