Pie Chart

[Luisanabria]

Hi all

I have a dude, lm using a Pie Chart to show the top 10 ranking and that is working ok, but in this case, l want to add to that top 10 my country.

Example:

Add to this TOP 10, My country

Is possible to do that?

Thank you all

[vinieme12]

You haven't mentioned what exactly do you need to add?

[Luisanabria]

Add another country in this case...that Top 10 and Mexico 

I dont know if is possible to do that 

[vinieme12 · Accepted solution]

Instead of using Field limitation  use a calculated dimension, 

example

Dimension

=aggr(only({<country={"=rank(Sum(sales),4,2)<=10 or country='Mexico'"}>}country),country)

Measure

sum(sales)

Or if you still want to retain 'Others' slice then as below

Dimension

=aggr(if(rank(sum(sales),4,2)<=10 or country='Mexico',country,'Others'),country)

Measure

sum(sales)

[Luisanabria]

Thank You it was really helpful

Another thing l learned by you.