Hi Everyone 
My solution this week converts the Date column from String to Date format and uses the -Moving Aggregation- node to calculate the Cumulative Sum for the YTD Sales. For the MTD sales, I have performed the same moving aggregation but this time after having extracted the month, I have cycled through each month using a -Group Loop-:
You can find my solution on the hub here:
Thanks
Heather