Help, I would like to number my Rank row in Cross Tab:
Rank | Student Name | AverageScore | Rownumber()
1. John Denis | 99 | 2
2. Mark Evans | 88 | 3
3. Clare | 78 | 1
I Sorted by AverageScore Column which is calculated by Total/Count GroupBy Student Name. I want to show user the ranking. But the =RowNumber() returns the default alphabet sequence number from database. Which function I could use to do the RANK column in CrossTab in Telerik reporting?