Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
You haven't mentioned what exactly do you need to add?
Add another country in this case...that Top 10 and Mexico
I dont know if is possible to do that
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)
Thank You it was really helpful
Another thing l learned by you.