Thank you a lot for your reply!
Unfortunately the YOY comparison is still based on the same week of last year. In addition the Week 5 of the current year is not showing with this solution.
Is there any other idea?
Thanks a lot for your reply!
I have tried your solution but the problem is that now the sales are not attributed in the correct week for the FY17. For example now for FY17 we have:
- Week 1 with 10435 sales -> This should be 8731
- Week 2 with 3457 sales -> This should be 10435
It is important to show the correct amount of sales per week but then calculate the YOY based on the next week of the previous year. Do you maybe have another suggestion on that?