I am assume you are trying to show the share of each city in a total 100%. This can be achieved by Percentage of Total calculation.
Sample.Steps are available in the packaged workbook.
Please add some sample data if your requirement is different.
Percentage Total.twbx.zip 37.0 KB
Yes, that is certainly something that I want. However, is there anyway to display the East on the left of the chart & Central on the right of the chart?
Also, from your data, is there anyway to choose using a dropdown list, allowing us to control each sides of the bar chart?
For example, both dropdown boxes would have "North, South, East, West & Central" and I can choose & change and the colour sections of the bar chart will change.
Yes, you can have a drop down list by right click on the Region filter-> Show Quick filter. Single drop down is enough to control each sides of the bar chart.
If you place the report & legend in a dashboard then you can adjust the legend width horizontal, east on left and center on right.
Another option is create two calculated fields for each region but it will complicate the above simple methods.