Stack bar sorting issues

[Anonymous]

Hi, find out sometime we can not sort thing as we want.

here I try to put 'Sum(Sales)' as top sorting criteria but i can not.

Any suggestion How could I sort the stacked bar in term of the total stack sales? (each bar belong to 1 category, could i rank them first from High to Low Sum(Sales))?

Thank you!

[OmarBenSalem · Accepted solution]

If you can't put sum(Sales) above categroy, in category try to sort by expression; an as expression; sum(sales):descending

[MK9885]

Maybe try below in your sorting?

aggr(Sum(Sales), KATEGORINAMN)