
Contributor III
2021-06-05
04:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank by Dimension
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.
- Tags:
- rank
1,763 Views
2 Replies

MVP
2021-06-05
09:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @Ronald
In second dimension, you can try like below
Aggr(If(Rank($(vMetric))<=10, Laboratory, 'Others'), Laboratory)
or
try like below
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
1,735 Views

Contributor III
2021-06-06
10:13 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Mayil, but "Others" repeat many times, not grouped. I need to show rank in dimension, is the first column.
1,710 Views
