Access Pivot Table Hierarchy In Report Filter

Hi,

Does anyone have any reading material on How to Access Pivot Table Hierarchy In Report Filter?

This describes my problem pretty much.

http://www.mrexcel.com/forum/excel-q...hierarchy.html

Here is the one I posted earlier..

http://www.excelforum.com/excel-char...ml#post4178022

Can't seem to find any documentation on this problem at all what so ever..

The Macro Recorder generates a code like this -

Please Login or Register  to view this content.

It will makes it a lot easier if you show us, manualy typed the result in the file you posted in your earlier threat.

Hi oeldere!

Thank you for the reply.

Can you tell me what exactly you want me to type in the Excel? I will do it..

Also, see the file attached for the scenario. What I am trying to do is select a date from the Drop Down on Cell A2, and get all the Pivots to select the Date on the report filter.

This code works perfectly..

Please Login or Register  to view this content.

However, my issue is, the Data is coming from a Cube, and the Report Filters show dates as a hirearchy, and which is where my code fails..

So I though of using the Macro Recorder to see what it generates when I select only 2 entries (Week Numbers) from the Report Filter, and it generated this code -

Please Login or Register  to view this content.

Any Help please?