Data Manipulation

[Polite123]

Hi Team,

I need some quick help in analysing below data.

In my process, there is one input sheet which is updated every month and used in the workflow.

Explanation:

1.When we place the above input file and run the process for January, it should reflect data for January month. February data should be average of January data.

Points	Months	Values
A	January	25
A	February	25
A	March	0
A	April	0
A	May	0
A	June	0
A	July	0
A	August	0
A	September	0
A	October	0
A	November	0
A	December	0

2. When we run the process for February using updated input file in Feb,new Feb data will be reflected.

March data will be average of Jan and Feb data.

Points	Months	Values
A	January	25
A	February	5
A	March	15
A	April	0
A	May	0
A	June	0
A	July	0
A	August	0
A	September	0
A	October	0
A	November	0
A	December	0

3. Similarly when we run the process for March using updated input file, new March data will be reflected.

April data will average of Jan,Feb and March data

Points	Months	Values
A	January	25
A	February	5
A	March	10
A	April	13.33
A	May	0
A	June	0
A	July	0
A	August	0
A	September	0
A	October	0
A	November	0
A	December	0

Kindly help.

Thanks in advance:)

[Polite123]

Also,I want it to be done through calender option.

Thanks

[Polite123]

Can anyone please help on above issue?