Please find attached a Workbook that I hope you can help me with. I have a Stock on Hand Table which gives a Daily Stock on Hand for each Product and Branch in my Company. There are only records for each Product and Branch where I have either Bought Something or Sold something.
There is a measure called Daily Stock that fills in the Stock on Hand for the days were the Stock on Hand would have been blank but is populated by taking the previous Stock in Hand. All that works ok.
What I cannot seem to figure out is the Total stock on hand for the whole product on a particular day.
The Spreadsheet has the data and the Total I am trying to find should be just over 8000 but I am a little lost.
The issue seems to be the date Context in that it will give me the Total for the actual Transactions but not the filled in gaps.
Hopefully someone can help.