Sort Stacked Column Chart by Y-Axis Value??

[#1]

How do I make it so the Business Unit with the largest quantity is at the bottom of the stacked column and the smallest at the top? Can this be done for each column? Do I have to sort by expression? If so, what would I write?

[vgutkovsky]

Well, you can't do it for each column independently, but you can sort it by the total quantity per Business Unit (regardless of month). Under sort, select Business Unit Group and then sort it by expression descending, where you expression is sum(quantity) or whatever you used as your actual chart expression.

Regards,

Vlad

[#3]

Thanks Vlad, the above answer is correct! Hunt please mark as correct