Thank you for taking the time to help me.
This is not what I was after though.
What I have is a hierarchy that is expandable from dimension 1 to 6. I want to be able to remove some chosen dimensions using a quick filter so the hierarchy changes to, lets say, dimensions 1-3-5-6 or 1-2 or 1-6, thereby changing the way the data is presented, rather than me have to create separate views.
I know I am not explaining this very well. Ill have another go.
If I had a hierarchy of country-state-county-city I want to be able to change this, via a quick filter, to display country-city or country-state-city or county-city. this way I can change the way the data is presented to find trends. At the moment I have to have a separate view for each permutation.
I hope this makes better sense.
I have the similar challenge here too. Do you have any solutions/workarounds on this challenge?