Sorting by a measure that is not used in the visualization

[SamuelHaag]

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

[dplr-rn · Accepted solution]

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

[SamuelHaag]

Thank you very much! I got it!