I have a pie chart in which I want to show the top 5 countries and grouped the rest as others. It is sorted by value in descending order but I want to keep the Others at the bottom. I tried the Bottom Overrides but “Others” is not an option.
Also, is it possible to use the Other Group measure as a filter control to show everything except the top5.
Does anyone have any ideas? thanks!
Hello @steven.chan,
Please check the following link: https://www.dundas.com/support/learning/documentation/analyze-data/displaying-top/bottom-records
If you would like to group/aggregate some countries based on a logic(conditions) , you can do it from the ETL part.
Thanks, Costin
I’m able to group the bottom countries, but my question is more about sorting the chart.
I want “Others” to be shown at the bottom/ last of the chart even when they have a larger aggregated value.
In my case, like this:
Haiphong
Philippines
Cambodia
Jakarta
Ho Chi Minh City
Others