Hi guys,
I have created a dimension hierarchy, with 4 fields, per example: A,B,C,D .
I'm using the sort by expression descending and alphabetical ascending and it's working.
My expression: if( fieldsortselected = Number, ValueForSort)
And I'm trying to add one more level, so the expected result is A,B,C,D,E. The problem is that the last level ( E ) is not showing the sorting icon ( triangle ) and the sorting ( by expression and alphabetical ) is not working. Do you have any ideas why it is happening?