I have an analysis services data cube connection. I would like some code where I can select a month in the following format January, February, March. etc. and it would filter the pivot tables for that month.


Unfortunately I cannot share this pivot table cube otherwise I would be fired
The field name in the Pivot Table is called [Post Date].[Month].[Month].


The pivot tables are in two different worksheets OB EPIC 1 and OB EPIC 2. Not sure if this is a key piece of information.

Thank you.