Thanks for providing your data sources. You may be able to get a more helpful response from our community if you provide a packaged workbook showing the work you've already tried to achieve your desired output. Otherwise, I would contact support and see if they can assist. Also, let us know if you've already found a solution!
I agree with Diego.
I took a look on your files and i couldn't between daily.
In my understanding MTD should be or the last value of month or the total sum of month.
In your files you have in MTD:
201602 20160228 50 25
201602 20160228 35 57
Can you explain us the concept?