Hi all,
I'm working with data which is daily uploaded from a live data source (stock data).
I've created a table with the stock of a certain set of items (last mutation date = 12-13 weeks ago)
"Refer to this as the selection date"
Now(say 8 weeks later), I would like to create a table which tracks the development in stock over this set of items.
So, something like the following
Selection date | selection date + 4 weeks | Selection date + 8 weeks |
---|
# of stock for item 1 at selection date | # of stock for item 1 at selection date + 4 weeks | # of stock for item 1 at selection date +8weeks |
# of stock for item 2 at selection date | # of stock for item 2 at selection date + 4 weeks | # of stock for item 2 at selection date +8weeks |
# of stock for item 3 at selection date | # of stock for item 3 at selection date + 4 weeks | # of stock for item 3 at selection date +8weeks |
I realize it's still a bit vague, but can anyone help me to create something like this. I think I need to store historical data on a weekly basis(with a week&year reference) such that I can load this data into a table like the one above.
Many thanks in advance.