Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Need your help urgently!!!
I need to sort the values as per attached excel .Rank column marked in yellow color.
Please help me for sorting this number in descending order
NOTE:I need to do this in front end.
I gotthe answer
logic used is rangeavg(rank(column(1)))
Data:
Load Name,
[D name],
[Index for month]
FROM Table;
New:
noconcatenate
LOAD *,
if([Index for month]=previous([Index for month]),peek('Rank'),rowno()) as Rank
Resident Data
order by [Index for month] desc;
drop table Data;
cool:)
Please close the thread by making correct answer.
i want it in front end expression