Is it possible to calculate totals for one month and use it for next month input?

[soumya1092]

I am trying to design a model where I want to calculate totals for the current month and carry forward the total value to next month as the input. 

I need the calculations to start from the current month till end of year. I tried creating a model where I transpose the input data and filter on current month do the calculations and use that calculation as an input for the next month.

I have attached the workflow and file. 

Is there a better way of doing this?

[LordNeilLord · Accepted solution]

Hey @soumya1092 

I think a multirow formula would do the trick here:

[MichalM]

@soumya1092 

Once you identify the current month, you can use the Running Total tool and Group by the Name column. This will do exactly what you're after for each of the entities in the name column.

Here's more on Running Total.