Show current line of table

[Anonymous]

Hi,

is it possible to show the current line of a table in the first column.

For example if the table got two entries:

current line	Header 2	Header 3
1	foo	bar
2	foo	bar

And if the selection results in a table with 4 entries:

current line	Header 2	Header 3
1	foo	bar
2	foo	bar
3	foo	bar
4	foo	bar

I hope my question is understandable.

Any hint or sollution is very welcome.

Thanks in advance

[Anonymous]

see the result below when I do that, that is exactly what I dont get.

Sort Priority is MyValue desc, then the Rank expression

[swuehl]

You are probably using more than 1 dimension, try

=rank(total sum(MyValue) )