Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a straight table chart with a simple Rank function that goes like this: =Rank([Expression]). This works fine. It ranks Descending. How can I get it to rank Ascending?
Thanks
Hi,
Please refer the attached application. u can use the -(minus) sign in rank function.
Use the same expression in sort order.
I think I should have explained better. What I have is expressions, ranking the previous expression. Example is
Expression 1 Expression 2
Rank([Expression 1])
4 2
6 1
3 3
2 4
Expression 2 is ranking in Descending order. I can't use the Sort Tab to achieve this because I have 8 expressions like 'Expression 1' and 8 expressions that rank these expressions. This is all in one table. Is there a way to rank in Descending in the expression?
Hi,
Please refer the attached application. u can use the -(minus) sign in rank function.
Thanks Manesh, does just what I wanted.