Pivot Table - Pick up value from previous column

pkelly — Wed, 25 Nov 2020 16:16:04 GMT

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?

topic Pivot Table - Pick up value from previous column in QlikView