I have this dataview and I would like to find a nice way to hide/show the 3, 6, 9 month columns without having to go into the layout and select the hide block option. I started off with a small data entry cube so that I can place a tick to decide which columns I want to show but I can't find a way to have that affect which columns can be seen on the data view.
Any good tips and tricks out there to help me achieve this?
Hi Adam,
I think you can easily solve this using a Dynamic Select.
A possible Solution could be following:
New Entity "Moving Avg Selection" containing following Elements "3 Month", "6 Month" and "9 Month"
A cube based on "Moving Avg Selection" and Month. In this cube you can configure which Month should belong to "3 Month", "6 Month" and "9 Month". Then you use this cube as a dynamic select (with option "periods <>0) and add a selector for the entity "Moving Avg Selection" on your screen. So with selecting one of those member automatically the entity month get selected cause of the dynamic select.
Regards
Björn