Find value from other line item and populate it backwards
Dimension: Time (Months)
Line item: Amount, Proforma (both Number format)
The Amount line item is imported based on imported forecast. I then want the Proforma line item to populate the first found value from Amount for all cells in current FY.
Amount is 100 from August to Dec 2020.
FY starts in Jun 20, so I then want the Proforma line item to get value 100 in all cells during FY, so from Jun 20 to May 21.