Rank should not change on selection

[rupaliqlik]

Dear All ,

I have Person wise data and their ranks, but when I elect any person rank is showing 1 . and I want their actual rank. Please tell me what I should do in this scenario.

Thanks in advance.

[Anonymous]

please prepare an example...

[ziadm]

What is the expression .. ?

you need to ignore the dimension in the Rank expression

[rupaliqlik]

Dear Robin,

I have data like this

A:

load * Inline

[

NAME, Marks

Rupali, 100

Smita, 90

John, 70

Aditi, 60

Prachi,  50

Priya, 40

Rina, 20

Mehul, 10

Disha, 15

Isha, 35

];

RANK Expression: =rank(sum(Marks))

while selection rank shows 1 .

Please suggest .

[rupaliqlik]

Dear Robin,

I have data like this

A:

load * Inline

[

NAME, Marks

Rupali, 100

Smita, 90

John, 70

Aditi, 60

Prachi,  50

Priya, 40

Rina, 20

Mehul, 10

Disha, 15

Isha, 35

];

RANK Expression: =rank(sum(Marks))

while selection rank shows 1 .

Please suggest .

[Anonymous]

dimension NAME

expression:

if(not isnull(Marks),rank(Sum({1} Marks)))

[ziadm]

aggr(rank(sum( {1<NAME=>}  Sales)),NAME)

[ziadm]

aggr(rank(sum( {1<NAME=>}  Marks)),NAME)

[rupaliqlik]

thanks @ !

[rupaliqlik]

Thanks.