Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am showing names based on the score and em restricting only top 20 names.
Using the below condition
IF (aggr(rank( sum(score1) ,0) , score1 )<= 20 , sum(score1) )
If the score =0 then em not able to see the person name.
I need to show the person name with score 0 as well.. as i want to show 20 names..
two person may have score 3 and 7 and rest may have score 0
how can i restrict only 20 considering the score 0
how can i do it?
Regards,
Prajna
Hi,
Instead of using rank function you can simply use dimension limit option..
make sure in presentation tab> suppress zero values should unchecked.
HTH
Sushil
Hi,
Instead of using rank function you can simply use dimension limit option..
make sure in presentation tab> suppress zero values should unchecked.
HTH
Sushil
Thank you
Regards,
Prajna