How do I not show some dimension value in a pie chart?

[Noor51]

Hello, 

I have a pie chart that I create, but I don't want to show a one value of the dimension. I don't want to remove the  data, I just want to change the order. The chart shows the top 10 companies in the market. 

I heard that script chart could maybe do it, but I don't know how to though. Down below is the chart. I want to ignore Hikma for the top 10.

[rwunderlich · Accepted solution]

Add a set expression to remove Hikma like:

{<Company-={'Hikma'}>}

-Rob

[Noor51]

Thanks for the solution. Is there a way so that it hide it because the % changes when I use it and I don't want the % to change? Or is there a way to put Hikma in the others section? 

Thanks

Gurnoor

[rwunderlich · Accepted solution]

You could put Hikam in the Others by using a calculated Dimension like:

=Aggr(if(Rank(Sum({<Customer-={'Hikma'}>}Sales)) <=10, Customer, 'Others'), Customer)

or if Sum(Sales) is already a Master Measure named Sales:

=Aggr(if(Rank({<Customer-={'Hikma'}>}Sales) <=10, Customer, 'Others'), Customer)

-Rob