Show top 5 and aggregate rest all to 'Others'

[KM]

Hi,

I need to display top 5 clients (based on revenue) and aggregate rest all clients to just a single row 'Others' 

 

C1 100

C2 150

C3 200

C4 250

C5 300

Others 5000

 

Please let know how I can achieve this.

 

Thank You!

[sdf]

Get to 5 :
if Relational source use Rank
if dimensional (cube) use TopCount

to get "other"
Total(all) - total(top5)

[hespora]

If on dimensional, there is a beautiful technique, outlined by Grandmaster Paul no less, to be found here: http://cognospaul.com/2017/03/06/quickie-top-5-top-4-others/

[dougp]

So, this is the same question you asked on stackoverflow?  See the answer there.

[Invisi]

I miss your visualization. If you will do it with a horizontal bar chart (the most obvious choice), then you can use the top-n option that the bar chart has.