Rank by Dimension

[Ronald]

Hi everyone,

I need to show top 10 ranking in dimension, but I need to show grouping "OTHERS" in bottom too. 

Top 10 is ranking by measure MAT ACT. Please your help.

[MayilVahanan]

HI @Ronald 

In second dimension, you can try like below

Aggr(If(Rank($(vMetric))<=10, Laboratory, 'Others'), Laboratory)

or

try like below

[Ronald]

Thanks Mayil, but "Others" repeat many times, not grouped. I need to show rank in dimension, is the first column.