Rank function: Top 10 but count greater than 1

[sifatnabil]

Hi, I am using the below rank function in a chart dimension but want to exclude any DeskName where count(if(Late='Y'))=1, i.e. only include a top 10 of those with count greater than 1. How can I put this condition in the dimension field?

=aggr(if(Rank(count(if(Late='Y',Id)))<=10,DeskName),DeskName)

[anbu1984 · Accepted solution]

=aggr(if(Rank(If(count(if(Late='Y',Id))>1,count(if(Late='Y',Id))))<=10,DeskName),DeskName)

Select "Suppress When value is Null"