4 Replies Latest reply on Aug 25, 2016 11:39 PM by Morgan DUARTE

    Combine actual and forecast file

    Morgan DUARTE

      Hi there,

       

      I have 2 files, one with actual data and one with forecast data for the coming 3 months.

       

      I got 2 issues there:

      - The forecast file is having variable months (Always 3 months in the file, with M, M+1 and M+2). It's then a dynamic field. We are now in Aug, so M = Aug. But next month, it's gonna be September.

      How can I set this?

      - Once this is solved, I need to combine both in a same table (1 value for 1 month) and ideally make a bar chart, with 1 color for actual, 1 color for forecast.


      Any idea on how to do it?

       

      Attached an example.

       

      Thanks a lot !