I am trying to create a bar chart that will show the top N cities versus the rest.
In order to do this I had to move cities to the detail and create an Index that will apply to the chart. Because of this I had to use a Reference Line instead of a Label.
I would like the label for % of Total Sales to move to the top and preferably not have the Tooltip summarize the grouping not the City. I do not want to use sets because they will not filter.
Screenshots and calculations are below in addition to the worksheet. Thoughts on how to solve this problem? Thank you.