Hi all - Not sure if it's possible but wanted to get some ideas. Have a stacked bar chart with 1 dimension and 3 expressions. User requirement is to sort it by sum of first two expressions (desc), which is doable i.e. Sum(Exp1 + Exp2) under Expression in Sort tab ... challenging part is in case there're are two or more rows (in this case bars) with same result, sort by 3rd expression (within those resulting rows/bars).
Has someone done something like this ?
Thank you.