9 Replies Latest reply on Oct 18, 2016 1:17 PM by Lisa Li

    Sum Data from two tables based on Month

    nataraj.vijayanagaram

      Hello Experts,

       

      I am new to the world of Tableau and so far enjoying the capabilities. I am working on a Dashboard and stuck with an issue. The question might be simple with a simple solution however I am not able to figure out how to get this done. So, requesting your help.

       

      I have two tables as below: One has the actuals as of date and the other have the forecast

       

      MonthActuals

      Jan

      6
      Feb15
      Mar15
      Apr16
      May16
      Jun17
      Jul18
      Aug19
      Sep20

       

      Second Table with Forecast:

       

      MonthForecast
      Sep1
      Oct2
      Nov1
      Dec3

       

      Using the above two tables I would like to create the chart similar to the below:

       

      Picture1.png

       

      I am not able to create a calculated field to get the sum of actuals and forecast. Can you please advise me on how I can achieve this.

       

      Thank you for all your support.