Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you ranked like
=rank(sum(Value))
then try
=rank(-sum(Value))
so the min of sum(Value) should be ranked 1.
If you ranked like
=rank(sum(Value))
then try
=rank(-sum(Value))
so the min of sum(Value) should be ranked 1.