Hi all, I would like to bring in the discussion of the topic in which title indicated. To illustrate the situation, I posted the two actions I did below:
So this is a normal Drill Down by:
And if I sort it by “Total Unit Sold” first and then Drill Down by:
The sorting mechanism overrules the hierarchy structure.
Btw it happens in the dimension hierarchy too.