Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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
Thank you, that works !