Rank()

[prajapatiamar38]

Hi Experts,

How to give a rank on expression without considering any diamensions in straight table?

no affect of diamension on rank function

Plz help me...
Thanks.

[Kushal_Chawda]

Create Rank from script

New:

LOAD * Inline [

City, Place, Name, Score

Mumbai, ddd, Prakash, 56

Pune, hghg, Anand, 56

Pune, rr, Raj, 56

Mumbai, AAA, Vijay, 55

Pune, tty, Akshata, 45

Pune, fffg, Suraj, 44

Pune, rr, Vijaya, 43

Pune, ygfh, Leena, 34

Mumbai, AAA, Pooja, 30

Mumbai ,Vileparle, Anil, 10 ];

Data:

NoConcatenate

LOAD City, Place, Name,

sum(Score) as Score,

autonumber(sum(Score)) as Rank

Resident New

Group by City, Place, Name;

DROP Table New;