Forecast vs Actual Data

dany26hdz05 — Sat, 16 Nov 2024 03:23:43 GMT

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?

topic Forecast vs Actual Data in App Development

Forecast vs Actual Data