How to sort a column with rank?

Hi all, I’m traying to sort a column according to the sales ranking, when I do it at the id level I have no problem

I have ranked the data like this
=rank([sum(sales) DESC], [daydate, category]

adding the following field does not the data can be sorted even if the rank value is correct


can’t you do it through gui?

1 Like

I’m new to the tool, sorry, it does work through the gui, thank you!!