Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
please prepare an example...
What is the expression .. ?
you need to ignore the dimension in the Rank expression
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 .
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 .
dimension NAME
expression:
if(not isnull(Marks),rank(Sum({1} Marks)))
aggr(rank(sum( {1<NAME=>} Sales)),NAME)
aggr(rank(sum( {1<NAME=>} Marks)),NAME)
thanks @ !
Thanks.