2020: Week 42
Challenge by Tom Prowse This week we are back in the (home) office after a week at Tableau Conference-ish and want to know how we are performing so far this year. As for most businesses, it's been a tough year so we want to find some comparisons between our sales this year, last year and our targets. We have two inputs: 1, Transactions This is a list of our daily sales for each product. It contains the Price, Quantity and Income. 2, Targets This is a list of targets that have been provided by the finance team. It is a weekly breakdown for this year by product. Requirements Input the Data Create a daily Targets table. Assume there are 7 days in the week and the daily demand is split evenly throughout the week. Eg, if the weekly target is 700, then 100 per day. Categorise whether a row/transaction happened this year, last year or is a target. Combine the Transactions & Targets tables. Only keep the Year to Date for each period. As the 9th Octo...