creating new fields

[Madhab77]

Hi All

I have the following input table and I need to have the second table as the output, could you please suggest any solution to achieve this. 

Thanks in Advance.

[Anil_Babu_Samineni · Accepted solution]

You mean like this, PFA

[Madhab77]

Hi Anil,

Thanks for you suggestion. Unfortunately, it was not my exact expectation. Your solution gave value for all the months, but my requirement is that the value should be populated for all the months which are From Start_Date to End_Date.

Thanks Anil, for you effort, which you put in for me.

[Anil_Babu_Samineni]

Change your initial post and update us to track, I see that your expectation is similar as per image? If you need full, You can simply use Sum(value)