Forum Discussion
Solved
Calculate Movement between datasets from different dates
I have previously created a weekly sales report in excel - using pivot tables. I also created a static "movement" tab by copying and pasting the previous week's figures next to the current week, and...
I resolved this by setting up a reference table with the names of all the products and a reference date table.
I was then able to compare the 2 datasets from the different dates by liking the booking date to the date table and the product name to the product reference table.
I resolved this by setting up a reference table with the names of all the products and a reference date table.
I was then able to compare the 2 datasets from the different dates by liking the booking date to the date table and the product name to the product reference table.
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.