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.


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).