This content has been marked as final. Show 2 replies
I have ID, Year, Country, Value in my table. I have to calculate rank for country for each ID and Year based on the value in script. More the value, best the rank.
For example, for year=2014, ID=1, I have value for 20 countries. I need ranking for them (so rank is from 1 to 20)
Similarly , I have more IDs for the same year, for which the rank should again start from 1.
Please suggest solution.