Macro new scenerio

[Former Member]

Hi All,

I have one macro scenario.

Data view is in WEEKS

Plz find the table below

	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8
Key Figure 1	500
Key Figure 2	4
Key Figure 3	125	125	125	125

I have KF Valu 500 in Week1 and This 500 value should distribute in KF3 according to the user enter the value in KF 2

If user entered 4 weeks in KF2 Week1 then the KF1 Week 1 value Should DISTRIBUTE in KF3 as above the table.

If any one know Plz Let me know how to write the logic.

Let me Know if any information is needed.

Thanks,