Top 10 in Chart

Hi Omer,

It’s a good idea that the product team is currently reviewing! You can upvote a similar idea here.

I also shared a workaround to make it using a metric if you need it right now.

If you build it in a grid, you can then turn it into a chart and it will keep the same items there.

Hope this helps you!

Is there a way to do this while then grouping the rest of the items into an “All Other” category? 

Example :

1.A

2. B
3. C
4. All Other
5. Total = A+B+C+All Other

Hi,

I believe you can do it this way:

Let’s assume you have a metric with a cost per supplier a a source.
 

First, I would create a parameter metric that allows me to dynamically change the top X suppliers. It's 10 for the example,.
 

For this second step, I create a ranking by supplier using the Rank function.

 

Then, I'll define all the suppliers that fall within the scope of the settings, the result of which is the top 10 as set in the previous metric.
 

Same logic for Other Suppliers:
 

Last step, I calculate the costs of the first 10 suppliers (first part of the formula).

I reallocate the remaining suppliers to an “Other Suppliers” element of the Supplier dimension in the second part of the formula.

And there you have it, a dynamic way of ranking your top X suppliers😊

Let me know if you need further explanation,

Ahmed