Beginning Balance Rollforward

Thanks lbendlin . I would need to show Beginning Balance only once, which should be the balance from prior years.

This should be followed by "Debits", "Consumption" and "Balance" for each month in the current year or year selected in slicer. Formula for Balance should be (for the first month in the current year, Beginning Balance - difference between "Debits and Consumption". Subsequent months it should be Prior Months balance - difference between that months "Debits and Consumption".). If the Beginning Balance / Balance for a specific combination of PO, Supplier and WBS is 0, Balance for that month should be just the difference between Debits and Consumption for that specific month.

If it's not possible to show Beginning Balance only once, that is okay. I can exclude Beginning Balance but show only Debits, Consumption and Balance.

Thanks,

Phani