2 Replies Latest reply on Apr 12, 2018 3:50 PM by Jeff George

    Dynamic Top Ten with Multi-Category Dimension

    Jeff George

      Apologies for the (potentially) unclear title, but I'm not really sure how else to phrase it, or how to solve this problem. I've attached a subject 10.0 workbook, so hopefully between that and this explanation we can come up with a solution!

       

      I'm using the INDEX() method to filter down to the top ten Manufacturers dynamically based on the State selected. When I select a state like California, I get the issue I'd like to address. On the "Table" sheet, I'm seeing what I expect, that is to say the top 10 manufacterers by total sales, even if they didn't use a specific shipping method. However, when I turn this into a chart (on the "Chart" tab), Tableau adds in extra Manufacturers on the bottom of the graph to get to 40 total marks. I'm guessing this has something to do with how I've filtered down to the top 10, but I'm not sure. Has anyone else run into a similar problem, and if so, how did you solve it?

       

      Thanks!

      Jeff