We need some suggestions for solving this calculation.
We have stores that perform daily inventory levels of various products.
Some stores do not report their levels every day, and may skip several days.
How do I provide a table of the actual inventory level on any given day for every store, even if a store did not report on the day requested, it picks the last inventory reported.
Example: Store 1 reports on Jan 1, 2,5,6; Store 2 reports on Jan 1,3,6; store 3 reports on Jan 1, 4, 6
I pick date Jan 4 to see levels as of Jan 4, the table should show the inventory levels for store 1 from Jan 2 ; store 2 from Jan 3 and store 3 from Jan 4.
