Hi,
Please see the data below which shows the opening stock purchases, sales & closing stocks. Since this goes as a routine process I wish to present this excel data arrangement in qlikview. Please show me our experts how this could be presented through expression to record opening stocks & in between transactions & then the closing stocks.(Note: Closing stock at the last Month should be the opening stock in the current Month & so on.
Thanks
Neville
Date | Purchases | sales | balance | | | |
1/1/2016 | | | 25000 | | | (Opening Balance |
1/10/2016 | 10000 | 2000 | | | | |
1/25/2016 | 12500 | 5000 | | | | |
1/31/2016 | | | 40500 | | | (Closing balance) |
| | | | | | |
2/1/2016 | | | 40500 | | | (Opening Balance |
2/10/2016 | 10000 | | | | | |
2/25/2016 | 5000 | 5000 | | | | |
2/28/2016 | | | 50500 | | | (Closing balance) |