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().

[Murugesan]

Hi 
You can sort the dimension (Store) using the sort by expression in Sorting tab

[simsa]

Alternately, you can use dimensionality() function:

If(Dimensionality() = 1,
    1,    // Data for regular rows
    2     // Data for totals
)