Number of table rows

[Anonymous]

Hi,

I'm trying to sort the table by sales column but it does not work. Do you have any ideas on that? Please see attached file for example.

Thank you for your ideas.

[sunny_talwar]

May be sort by your dimension using an expression:

[maxgro]

Do you need the Rowno(TOTAL) expression? Without that you can sort as usual double clicking on the label

[Anonymous]

Yes. I need to show number of rows in the table. Maybe it's possible to use any other expression to show number of row?

[Anonymous]

Thank you, but this construction is strictly predefined and I cannot select other fruit - for example, "peach"

[sunny_talwar]

I don't understand? We are looking at just apple and the data is sorted in the descending order. Not sure what the issue is? Can you elaborate may be?

[swuehl · Accepted solution]

Not sure what you are trying to achieve with the rownumber, but if you want to show a rank, try

=Rank(TOTAL "Sales",4)

instead.

[Anonymous]

Thank you - it's what I need and it works.

[Anonymous]

Thank you, this question was solved.