Top 5 number from N number of rows.png
Hi please go through the following and would be great if anybody share the solution.(Top 5 rows for respective entities,If entity row count<5 then ranking for all row against that entity)
Entity Value Top 5 rank value
A 14
A 9.4
A 23.2 3
A 11.2
A 17 5
A 23.4 2
A 21 4
A 2
A 55 1
B 34.4 1
B 4 4
B 22.4 2
B 11.3 3
B 2 5
C 2
C 12 2
C 5
C 8 5
C 1
C 12 2
C 23 1
C 7
C 11 3
C 10 4
C 6
D 5 2
D 2 3
D 12 1
Bookmarks