Pivot Table - Pick up value from previous column

[pkelly]

Hi All

I have the following Pivot Table:

I have the following formula in the OnHand row:

=If(fom_AnalysisPeriod = varPeriod01, SUM({<fom_AnalysisPeriod = {'$(varPeriod01)'}>} fom_InventoryOnHand), Before(Column(6)))

Mar 2020 is picking up the correct value of 10 as this is the current on hand figure.

Apr 2020 should be picking up the stock figure for Mar 2020.

Any ideas?