Who are Other? Did you group some of them?
If Other is UK + Japan it's no possible to show this way.
Other $41 $43
UK $23 $15
Japan $18 $28
I'll buid a sample.
You should be able to do this if you want to show the top N and the rest as others.
Follow this article to achieve that result: Create Sets for Top N and Others | Tableau Software
I have also attached a workbook with an example using Super Store Sales and Sub-Category to demonstrate the results.
Please reference the following:
- Top 5 Sub-Cat (set)
- Top 5 or Other Label (dimension calc)
- Expand/Collapse (parameter)
- Sub-Cat (dimension calc)
Top 5 or Other Example.twbx 346.1 KB