Rank if the sum is 0

[#1]

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

[sushil353 · Accepted solution]

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

[#3]

Thank you

Regards,

Prajna