Country Level WSSI
Budget: $30 – $250 USD
I am looking for someone to help formulate a country-level WSSI (Weekly Sales, Stock, and Inventory) report in Power Query. This report should be able to update automatically every week as the data actualizes once the raw data is dropped in the folder.
Every week i will paste the raw data in a folder (to keep things simple now i have linked it to the template) and once the data is pasted i will update the Wk tab to show the current week.
I have attached the template that i started working on, the data set provided has Week (wk 1 - 52), Current Week (Elapsed, Prev, Yes & Unelapsed) Country (markets 1 -& 2), Sales (at Cost Quantity and Retail) the remaining columns are all at Cost, Intake, Markdown, Opening and Closing stock. I am having difficulty in calculating a rolling closing stock number for future weeks.
Thanks
Every week i will paste the raw data in a folder (to keep things simple now i have linked it to the template) and once the data is pasted i will update the Wk tab to show the current week.
I have attached the template that i started working on, the data set provided has Week (wk 1 - 52), Current Week (Elapsed, Prev, Yes & Unelapsed) Country (markets 1 -& 2), Sales (at Cost Quantity and Retail) the remaining columns are all at Cost, Intake, Markdown, Opening and Closing stock. I am having difficulty in calculating a rolling closing stock number for future weeks.
Thanks