1 Reply Latest reply on Mar 29, 2012 6:32 AM by Jonathan Drummey

    Displaying the sub items in a line chart

      Hi,

      Suppose I have monthly total sales that is made up of sales of several different items. I can draw a line graph that would show how my total sales varied over time. I would like the user to be able to click at any point on the graph and see the Top selling items each month.

      Can this be done somehow in tableau?

       

      Thanks,

      Ram.

        • 1. Re: Displaying the sub items in a line chart
          Jonathan Drummey

          Hello Ram,

           

          Here's one way to do this, using the Superstore Sales data in the attached workbook:

          1. Create your line chart for Sales.

          2. Create another view that is a text table for Products.

          3. Create a dashboard. Drag your first two views onto the Dashboard.

          4.Go to the Dashboard menu and select Actions... Add a Filter action on Select with the source of Sales, and then Target of Products. Click OK.

           

          screenshot10.jpg

           

          Now when a user clicks on a mark on the line in Sales, the Products view is filtered. I added a bit to the title of the Products worksheet to show the filtered data, you could do this with a calculated field as well that wouldn't show "All All" when no mark is selected.

           

          Jonathan