Skip to Content

Macro new scenerio

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.


Be the first to leave a comment
You must be Logged on to comment or reply to a post.