Rank in reverse order

[#1]

Hi,

I wanna find the min and max value of a line graph. I have founded a way to do so. But im not able to reverse my rank

If i rank my expression i get the min value as Rank 50 and max Value as Rank 1.

Now i wanna new expression which ranks the other way, so i rank my Min value as 1 or -1 and max value as 50 or -50.

Can anyone help?

Thanks

[swuehl · Accepted solution]

If you ranked like

=rank(sum(Value))

then try

=rank(-sum(Value))

so the min of sum(Value) should be ranked 1.