Hi! I need some help here!
Every month our users calculate forecast for the following 16 months, so every month i have a different version of forecast and i have to save them all.
The resulting table has the following fields
"Cedis_Producto_Periodo" (This is a key that shows the forecast for the combination of month-year, product and distribution center) If this file is from November2019 then the month-year will be 201911
"Forecast Sales" (The forecast sales)
"Forecast Period" The 16 forecast periods i was talking about, If this file is from November 2019 then it will have fom 201911 to 202102
And i Have my Tickets table, this table contains all the data about sales, this table is linked to my master calendar.
The requirement is that they want to see a line chart comparing real sales vs forecast, for example, i have data until January 2020, if i select November 2019 i want to see real sales from November 2019/December 2019/January 2020 in one line AND in the other one i want to see from November 2019 to February 2021 with the forecast values from the November file.
Any Ideas?
