how the restric the month level data in pivot table

[#1]

Hi friend.

I have a requirement here..

I have to do one dashboard some thing like this...

we have hierarchy data stored in the pivot table, (year>month>week)

when ever I have to clik the month in wise data , week data should n't be showed and my table display only month data.

how can I do that..

[danieloberbilli · Accepted solution]

Please find an example attached. I assumed that you have Listboxes with Year, Month and Week values. When you select a value in Month, the Week column should be hidden, right?

I solved this using Enable Conditional for Dimensions: