2 Replies Latest reply on May 7, 2013 10:26 AM by Tsai Yin Yen

    Quarterly Sales Comparison

    Tsai Yin Yen

      I am trying to compare quarterly sales with a bullet graph, much like the Sales Sample Workbook that came with Tableau (image attached), but instead of annual sales, I'm doing it by quarter. In the attached workbook, you can see that I've created something similar, but it's not exactly what I want. The graph I have right now displays Previous Quarter Sales as the bars and Current Quarter Sales as the lines, which is opposite of what I'm looking for. Ideally, I would like to have Current Quarter Sales on the bars and Previous Quarter Sales the lines. When I tried swapping the two pills, i.e. having Current on Columns and Previous on the Marks shelf, I can't quite recreate the bullet graph that I have right now. Does anyone know why that is and how I can get the display I want?

       

      Any help and suggestions are welcome. Thanks!