I don't think there is an easy or straightforward way to do this.
Possibly you could create a single hierarchy consisting of two calculated items. The expressions for those two items would each return a different category, based on a parameter value that is set by a button bar or drop-down list control.
I have not tried this, but I believe it should work.
The calculated expressions would look something like:
IF 'parameter'p = "A"
RETURN 'A'n
ELSE 'B'n
and the other one would be the opposite:
IF 'parameter'p = "A"
RETURN 'B'n
ELSE 'A'n
I'm not sure how useful this is, because only the values would be dynamic. The names of the hierarchy levels would not change.
... View more