Order by a measure without showing it on graph

[Saryk]

Imagine we sell 4 items, A, B, C and D ; and we have 10 employees E1 - E10.

I have a stacked bars graph that has as a dimension the employees, and as measures the number of sales of each item - so sum(SalesA), sum(SalesB), etc.

I would like to order the employees by descending order of total sales, but I don't want to show the total number of sales in a separate measure, since I already have it at the top of my stacked bars.

How can I do that ?

[lironbaram · Accepted solution]

in the chart 

under the sorting tab : 

select the employee dimension 

change the sorting from auto 

then select sort by expression 

and inside put your expressions for total sales

[Saryk]

Thank you, that works !