Accumulated
To see the next 12 months' budget accumulated in a column on a rolling basis, i.e. independent of the fiscal year, set the column as shown in the image:
Meaning:
- Interval: Relative
- Resolution: Month
- From: 1 Month
- To: +12 Months
- Column formula: Custom: SumLast(Budget(RowFormula),12)
This requires that there is an active budget for the months to be covered. It is possible to increase the number of months, but then you need to change both the Added value and the Column formula.
Monthly columns
To get the same values but month by month, you enter the same settings but without SumLast() in the column formula, i.e.:
ColumnFormula: Custom: Budget(RowFormula)