Hello. In the List Designer for hyperblocks, there is an option under Advanced to "Invert hierarchy". This option is not visible in the List Designer for slices--is there a way to do this in slices? Perhaps through a custom mdx? Thanks.
The easiest way to invert the hierarchy is in the slice definition. AFAIK you can't change the order from the resultant hyperblock.
The screen shot shows the setting for rows. In this example I am not inverting the hierarchy.
Thanks John! Mine wasn't showing that option, but I figured out why. I had to change the "Expand and collapse" option to False, then the option appears. If you leave it as True, then you won't see that "Invert hierarchy" option.
