Sorting based on expression doesn't work after adding "rowno(total)"

[aheavy95]

Hi all 

Ran into a small sorting problem 

In this straight table, I want to show the row number to show where stores rank among others sales wise.

But once I add the -rowno(total) measure  the sorting that is selected by the Sales column does not work as stores are being sorted by the store number instead.

How can I solve this? hopefully there is a way

Thanks!

[marcus_sommer]

AFAIK each usage of rowno() will disable the sorting. You may try to replace the rowno() with rank().