Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
is it possible to sort by a measure that is not used in the visualization?
For example: I have a bar chart that shows the "Sales" of 10 Cusomters. I want to sort these 10 customers by the field "Contribution margin". So what I want are the sales of the 10 Customers with the highest "Contribution margin".
What I tried is something like this to sort it but it didn't work:
if(max([Contribution margin]), dual([Customer], 1),
if(max([Contribution margin],2), dual([Customer], 2),
if(max([Contribution margin],3), dual([Customer], 3),
if(max([Contribution margin],4), dual([Customer], 4),
if(max([Contribution margin],5), dual([Customer], 5),
if(max([Contribution margin],6), dual([Customer], 6),
if(max([Contribution margin],7), dual([Customer], 7),
if(max([Contribution margin],8), dual([Customer], 8),
if(max([Contribution margin],9), dual([Customer], 9),
if(max([Contribution margin],10), dual([Customer], 10)
))))))))))
Thank you ver much!
Samuel
Yes. go to sorting section as add the expression needed.
e.g. i have a table woth Month year as dimension and Sales as measure but i want sort by number of order. i create a regular table. order it by Monthyear. then go to sorting section and change as below picture
Result
MonthYear | Sales |
May-1998 | $18,333.63 |
Jun-1997 | $36,362.80 |
Mar-1997 | $38,547.22 |
Jul-1997 | $51,020.86 |
Jan-1997 | $54,326.47 |
Feb-1997 | $38,483.63 |
Apr-1997 | $53,032.95 |
Aug-1997 | $47,287.67 |
Nov-1997 | $43,533.81 |
Sep-1997 | $55,629.24 |
May-1997 | $53,781.29 |
Oct-1997 | $66,749.23 |
Dec-1997 | $71,398.43 |
Feb-1998 | $99,415.29 |
Jan-1998 | $94,222.11 |
Mar-1998 | $104,854.15 |
Apr-1998 | $123,798.68 |
Yes. go to sorting section as add the expression needed.
e.g. i have a table woth Month year as dimension and Sales as measure but i want sort by number of order. i create a regular table. order it by Monthyear. then go to sorting section and change as below picture
Result
MonthYear | Sales |
May-1998 | $18,333.63 |
Jun-1997 | $36,362.80 |
Mar-1997 | $38,547.22 |
Jul-1997 | $51,020.86 |
Jan-1997 | $54,326.47 |
Feb-1997 | $38,483.63 |
Apr-1997 | $53,032.95 |
Aug-1997 | $47,287.67 |
Nov-1997 | $43,533.81 |
Sep-1997 | $55,629.24 |
May-1997 | $53,781.29 |
Oct-1997 | $66,749.23 |
Dec-1997 | $71,398.43 |
Feb-1998 | $99,415.29 |
Jan-1998 | $94,222.11 |
Mar-1998 | $104,854.15 |
Apr-1998 | $123,798.68 |
Thank you very much! I got it!