Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement wherein I have to do the ranking of values in ascending order. For Example lower the values, higher the rank.
Value Rank
1 1
3 2
8 3
10 4
Can you please suggest how to use the Rank function to get the desired result.
Regards,
Raghav
Hi Ajay,
Tried the same.... still zero is not getting ignored.
Regards,
Raghav
Hi,
In which chart you aare trying this..
If you are using Pivot then check whether the "Supress Zero Values" is checked or not in Presentation tab.
can you attach the sample file...
Regards,
Ajay
Hi,
In which chart you aare trying this..
If you are using Pivot then check whether the "Supress Zero Values" is checked or not in Presentation tab.
can you attach the sample file...
PFA file
Regards,
Ajay
Hi,
If you change the expression with "
Rank((Sum({$<SALES={"<>0"}>}SALES)*1),0,1) " it will work accordingly...
-Jai
did you ever solve this problem? I have the same one unfortunetly...
HI,
Try this.
if(Sum (SALES) > 0, rank( sum( SALES ),0,1),0)
Regards,
Kaushik Solanki
Thanks!
But my problem now is that there's no number 1 even if it is the lowest one. ranking starts with 5 if there were 4 zero values in the range.
I'm coloring the values that are highest and lowest and i do this by hardcoding them right now. do you have a better suggestion for me?
Thanks again!
//A.
Hi
Please upload the file.
Regards,
Kaushik Solanki
here you go,
if you do changes and send it back i wont be able to download it for some reson (probably firewall) so pleas write the expressions as long as you can!
Thanks!
Hi,
I coudnt find anything starting from 5.
Please take a screen shot and post here.
Reagards,
Kaushik Solanki