FSG - Different Offset in Column Definition and Header

Hello,

In an FSG report we would like to display the FY Opening Balance by taking the YTD-Actuals balance from the CLOS period which is in the previous FY. For example the OCT-FY2020 (start of FY) opening balance is obtained by using the YTD-Actuals balance from CLOS_FY2019 (close of prior FY). That is the offset for the column definition. In the Header we'd like to display the first month of the Fiscal Year which is the period of interest - OCT_FY2020.

The offsets are different for the column definition (the balance we want in the top section) and the relative header (what we want to display in the report (the bottom section). I don’t see why this should be a problem but it only wants to display the relative headers when the offset matches what’s in the column definition.