Inventory Snapshop

[dkbollig]

Hey There

Our sales director would like a worksheet that shows the change of inventory over time ex: what did was the total stock of Product A at Dealer A Yesterday and What is the the total stock of Product A at Dealer A Today to see the change of inventory. So I'm thinking we would need to set a inventory table that SUMS the total stock for that day. I believe it would have to be scripted to run every day in order to work. What do you guys think of this? Anyone have experience in doing this?

Thanks in Advance
Derek

 

[cyrilbrd]

Hi, pivot may give you what you require.
Dates could be in Column Labels and inventory in Row Labels.