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.
Find my approach stored in the attached workbook. This will work with filters too.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...