Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
AFAIK each usage of rowno() will disable the sorting. You may try to replace the rowno() with rank().