We are trying to work on a Pivot Table that will help us look at transactions
for our inventory. We are pulling out a month's worth of transactions from an
SQL Server into a worksheet that lists the date, the type, the product and
the qty. From there we can use pivot table to do a summation and see the
total transactions on a daily basis, but we would also like to be able to
compare this to where our total inventory level should be for each product.
We would like to be able to input what the inventory level is at the
beginning of the month and then add and subtract the transactions each day to
see where the inventory level is each day. Does anyone have a suggestion or
an example of how to do this?