How to sort Pivot table, on the basis of two column

[Anonymous]

Hi All,

I have a pivot table in my application ( Qliksense). now we have two columns in it

1- SalesMargin

2-Expense

Now i want my table to be first sorted by SalesMargin , but if the value of salesmargin is same in two entries it will be sorted according to my second column Expense.

Will this be possible ?

Thanks in advance

Gaurav

[marcus_sommer]

Have a look here: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

- Marcus

[BeeGees]

Its old topic, my recently needed to solve the same issue. Proposed answer here, solves different issue (different sorting on each dimensionality). The right answer here is as below:

ValueColumnA * max(ValueColumnB)*10
+ ValueColumnB
+ ValueColumnC * min(ValueColumnB)/10

That way it will sort with columns A, B, C. Asc/desc can be accomplished by replacing plus "+" with minus "-"