I am looking for a simple way to sort descending within 2 dimensions based on the values of one column (latest month of data) in a Qlik Sense pivot table.
I can not provide actual data or my Qlik Sense file but a a rough example of the data is below where the descending sort would show REGION A first at it totals to 12 in Feb (latest month) which is higer than REGION B's 10. Then within REGION A, CITY1 is first since it is has the highest value in Feb and within REGION B, CITY3 first since it has the highest value in Feb :
COLUMNS Jan Feb
-REGION A 6 12
--CITY1 2 10
--CITY2 4 2
-REGION B 8 10
--CITY3 2 6
--CITY4 6 4
I have tried putting the below expression in a sort by expression descending for both dimensions: <sum( if ( MONTH='Feb' , Value-Feb, ) )>. This and various combinations thereof have not worked.
