3 Replies Latest reply on Aug 8, 2018 6:30 AM by Zhouyi Zhang

    Table reporting, Forecast vs Actuals

    Thomas Kont

      Hallo All,

       

      i need some help with the following:

       

      i need to create a table report on Tableau which derives from 2 different data sources (Actual Data and Forecast Data). I need this to be dynamic, meaning that every month the actual column should be filled with data from last month, which derives from the Actual Data File. The "Delta" column also needs to be there to show a comparison for last months Forecast vs Actual.

       

      Please find attach the two excel data for the sources.

       

      The report based on the 2 data sources, should finally look like the table below in Tableau if possible. 

       

      FC - Jul 2018ACT - Jul 2018DeltaFC - Aug 2018FC - Sep 2018
      Sales1.000.000,001.100.000,00100.000,001.200.000,001.300.000,00
      Cost700.000,00770.000,0070.000,00900.000,001.000.000,00

       

       

      Thanks a lot

       

      Regards

      Thomas