Allocate values to the following months

Hi!

There are two options you can explore - using either PREVIOUS or PRORATA. 

PREVIOUS is a function that can be used to “push” the data. In your example, you could use it in combination with IFBLANK and type a formula like this 

IFBLANK(JobOpening.FTE[FILTER: XX][BY COUNT: YY], PREVIOUS(Month))

This means if you have a value, take the value, if not take the previous month’s value.

I prefer working with PRORATA though, especially on larger datasets as it tends to compute faster (which becomes handy if you have millions of rows, or a very large calendar).

So instead of JobOpening.FTE[FILTER: XX][BY COUNT: JobOpening.'Position ID', JobOpening.'Arrival Date (Dimension)'], you can type

PRORATA(JobOpening.FTE[FILTER: XX], JobOpening.'Arrival Date')[BY COUNT: JobOpening.'Position ID']

By providing only a start date for the prorata, it will be continued until the calendar ends. Be mindful you have to provide a date and not a dimension like in the BY.

Hope this helps!