Attached is an app that shows all of the inventory activity for items in each store (i.e. beg bal, sales, transfers in&out, adjustments). I am trying to create a running balance column for each item in each store. I used AGGR in the pivot table to isolate each transaction quantity per store, item and transaction type. I am trying to use AGGR in the pivot table also to calculate the running balance by aggregating the beginning balance of each item per store with the sales, transfer and adjustment activity per store.
I am not seeing where the problem is in calculating the running balance. I tried creating the running balance calculation in the pivot table and in the load script.
Thank you in advance for any assistance with this issue!