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.