Top 20

[master_student]

Hello Guys,

I need your helps as usual

I have a table that contains a measure count (case) and field details, I wanna display the TOP 20 detail according to their count (case) and whene two details have the same count(case) display only the first :

the measure count (case)

[sunny_talwar]

You want over top 20 or top 20 per type cas?

[master_student]

Top 20 details according to their count case

[avinashelite]

add the calculated dimension for details like below

if(aggr(rank(count(case)),Detail,Type cas)<=20,Detail)

[sunny_talwar]

May be like this

=If(Num(Num#(Rank(Count(Case), 0, 2))) < 21, Count(Case))