Hi all,
I am trying to filter a Pivot Table that has a OLAP source, by multiple ItemId's in the worksheet.
The values that I want to filter by is in cell A2 and down. The list of ItemId's that should be visible in the Pivot Table could be anything from 1 to 500
As a small test i wrote the...