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 -

 ActiveSheet.PivotTables("PivotTable12").PivotFields( _
        "[TIME VIEW].[Date Hierarchy].[YEAR]").VisibleItemsList = Array("")
    ActiveSheet.PivotTables("PivotTable12").PivotFields( _
        "[TIME VIEW].[Date Hierarchy].[QUARTER]").VisibleItemsList = Array("")
    ActiveSheet.PivotTables("PivotTable12").PivotFields( _
        "[TIME VIEW].[Date Hierarchy].[MONTH]").VisibleItemsList = Array("")
    ActiveSheet.PivotTables("PivotTable12").PivotFields( _
        "[TIME VIEW].[Date Hierarchy].[WEEK]").VisibleItemsList = Array( _
        "[TIME VIEW].[Date Hierarchy].[WEEK].&[2013]&[1]&[1]", _
        "[TIME VIEW].[Date Hierarchy].[WEEK].&[2013]&[1]&[2]")
    ActiveSheet.PivotTables("PivotTable12").PivotFields( _
        "[TIME VIEW].[Date Hierarchy].[DAY]").VisibleItemsList = Array("")