Ive run into this issue several times. When I have multiple dimensions in the row section of a slice and only one of them needs to have the hierarchy inverted, sorting seems to follow order in which dimensions are added to the Row section.
For example, in the screenshot above, I want ChartAccount to be inverted and sorting priority to be AE, FD1-6 and CharAccount last. To get ChartAccount to invert though it would need to be moved to the top of the Rows section. however doing this, Sorting precedence is applied ChartAccount, AE and then FD1-6. The order defined on the Axis Designer is ignored.
I tried using Custom MDX as its shown in the user guide, Creating intra-hierarchy sorting with custom MDX but it returns blank results when using custom MDX.
