1 Reply Latest reply on Sep 19, 2018 9:37 AM by Tushar More

    Aggregate Top N Text and Filtering

    Peter Weldon

      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.