Stock on hand at a point in time, I only have current stock holding.
Alright so i would like to see my stock on hand but in a point in time.
We only have current stock on hand. We have all transactions in our Qlikview model, Sales, recieving, credits etc.
So i am looking to work backwards from current stock on hand and subtracting/adding several transactions to get month by month stock holding for previous months. This is to assist in stock analysis, we want to identify if we had bad sales due to out of stock or just bad sales due to other factors.
Please attached excel file, this is what i want to achive on Qlikview.