Hi p45cal
"Clarification needed.
YTD seems to be dates starting from the beginning of the calendar year to (in your file) Sat 30 June 2018. This is backed up by Week filter in the YTD pivot including 1 to 26."
- 2018 for me started on Sunday the 31st December 2017 therefore YTD starts on that date.
"MTD seems to be different. Rather than starting from the beginning of a calendar month, in your file you have 5 weeks of data starting Sunday 27 May 2018 and ending Saturday 30 June 2018. That includes 5 days in May as well as all of June; this may be a small mistake on your part, but I need to know whether you want just 4/5 weeks' data or data from the begining of the calendar month (1st June 2018, similar logic to YTD)."
- each quarter of the year has a period of 13 weeks, the first 2 months have 4 weeks and the last one has a 5 week period.
- each week starts on a Sunday and may not be the first day of the calendar month (in fact the month of June started on Sunday 7th May)
___________
The columns H-I; O-P; V-W are feed by the pivot.
The columns K-L; R-S; V-Z canīt use the same method because I need to compare only the dates which the store opened last year.
As an example store 104 (opened on the 14 April 2017) last year in YTD collumn till week 26 did 236,093 and this year already did 463,037 growing 96.12% but this is not the correct growth because LY the sales are only from week 15 to week 26. in fact I need to have the like for like figures.
Thank you very much for helping
Best
Ricardo
|