2 Replies Latest reply on Mar 30, 2017 2:27 PM by Chai Reddy

    How do I plot a multi line graph with data in weird format

    Chai Reddy

      I've been trying to get this to work since the past week. This is how my data looks:

      tableau help.PNG

       

      It's got the part no. on the left and has the shipment history in yellow and the sales forecast in blue.

      What I want to do is plot a multi line graph that has all this data and the calculated projected forecast as shown.

      Untitled drawing (3).jpg

      I was able plot my ship and sales fcst data by pivoting the data. But I'm stuck when it comes to getting the projected forecast to show because I was unable to run a calculation on pivoted values.

      Any help with this would be greatly appreciated.

       

      Workbook attached