sort on multiple columns of a straight table

[ali_hijazi]

Hello got a straight table with one dimension

and 3 expressions

Ex1, Ex2, Ex3

I'm sorting data on Ex2 and getting something like this

Dim1, 1, 100% , 751

Dim2, 1, 100%, 752

Dim3, 35, 100%, 27

....

DimX, 193, 100%, 1

DimY, 234, 95%, 67

...

So far sorting on Ex2 is fine as all values as 100% are on top of other values

but what I want is that the row which is in bold should come on top of all because the value of Ex3 is the minimum

so I want to sort by Ex2 desc and Ex3 asc

is this possible?

Please advise

[Gysbert_Wassenaar]

You can set the sort priorities and the sort order on the Sort tab of the properties window of the straight table.

[Anonymous]

goto sort tab

promote ex2 to first place and select desc

promote ex3 to second place and select asc

that should work

[ali_hijazi]

the problem is that the user got 3 buttons that set a variable to either 1,2, or 3

in the sort tab I select my dimension and checked the expression and put inside

if v=1 then ex1, if v=2, ex2, ex3

what I want when v=2 I want to make this sort to be Desc by Ex2 and Ex3 asc

can this be done in the expression sorting of the sort tab?

[Anonymous]

I suppose that is not possible

you may try to create a new field which is concatenated with Ex2 and Ex3

maybe like this Ex2 & (1000-Ex3) as Sortfield

that should give you datasets like

Dim1, 1, 100%, 751, 100249

Dim2, 1, 100%, 752, 100248

..

DimX, 193, 100%, 1, 100999

DimY, 234, 95%, 67, 95933

you goto sort tab and select if v=1, then ex1, if v=2 then Sortfield and you define descending

if Ex1 has Format percentage, you might to convert it to normal number

if for v=1 ex1 is not in the desending order you need another artificial field as well

[ali_hijazi]

not 100% accurate