Rank by group

[#1]

Hi,

I have an excel sheet with two columns e.g.

ID	RATING
1	-20
1	50
1	-1
1	0
2	100
2	-15
2	98

I want to return the top rank by ID so ID 1 would return 50, ID 2 100 etc.

any ideas how to code this as a calculated dimension?

Thanks

[Anonymous]

perfect !!