Actuals Total vs Forecast per Week

[joshua1990]

Hi experts!

I am no sure how this concept is called but I need to calculate the how much of the actuals fall into WK01, WK02 etc. Forecast.

The table is presented in the following way:

Product	WK01	WK02	WK03	Actuals
A	550	40	700	600
B	600	300	300	500
C	0	500	0	250

Now I need to calculcate the amout per week that is covered by the actuals like this:

Product	WK01	WK02	WK03	Actuals	Actuals WK01	Actuals WK02	Actuals WK03
A	550	40	700	600	550	40	10
B	600	300	300	500	500	0	0
C	0	500	0	250	0	250	0

I would need a measure for Actuals WK01, WK02 and WK03.

How would you calculate ?

[ahmetyilmaz]

Hi, can you explain how you obtained the data in table 2?