How to sort inner segments of Stacked bar ?

[KhatiaKil]

Hello,

I have been trying for days to sort inner segments of each stacked bar to decreasing order without any success. I really need this to be fixed. Can someone please help me 😞

I have two dimensions- Week and Name. One measure- Sum of the values. 

Orange one on each bar corresponds to "other ". I want "others" always to be fixed on one location- on top and the rest of the colors on each bar should be in decreasing order. Then, Ideally, legend of the names should be sorted in the way like the last week's segments( The highest value name on top, then the rest, and "totals" in the end).

I have tried with dual(name,aggr(sum(values),name,week) and then ticked sort to numerical descending but this did not work ( According to this solution https://community.qlik.com/t5/New-to-Qlik-Sense/Sorting-inner-segments-of-Stacked-Bar/td-p/1436519)

Can someone help me please.

[denispillay]

=if(GetSelectedCount(Category) > 1 or

GetSelectedCount([Zone]) > 1  or

GetSelectedCount([Class]) > 1 ,

0,

1)