Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
see the result below when I do that, that is exactly what I dont get.
Sort Priority is MyValue desc, then the Rank expression
You are probably using more than 1 dimension, try
=rank(total sum(MyValue) )