Hi All
I have the following Pivot Table:
![Image 17-04-2020 at 10.48.jpg Image 17-04-2020 at 10.48.jpg](https://community.qlik.com/t5/image/serverpage/image-id/32024i26E7B4BFDA16DCE5/image-size/large?v=v2&px=999)
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?