Lots of ways and it depends on what you're after. If it's always based on the current date, you could just load up YTD, QTD and MTD flags with your raw data based on the sales date vs. today(). Then just reference the flags, such as:
Dimension = Date
YTD = sum({<YTD={1}>} Sales)
If it's always based on a selected date, or the most recent selected date, then something like:
YTD = sum({<Year={'$(=max(Year))'},Quarter=,Month=,Date={"<=$(=max(Date))"}>} Sales)
If you want to be able to see all the dates of the year, each with their own YTD, QTD, MTD data, all at the same time, then I'd handle it with data:
AsOf:
LOAD DISTINCT Date as AsOfDate
RESIDENT Whatever
;
LEFT JOIN (AsOf)
LOAD AsOfDate as Date
RESIDENT AsOf
;
INNER JOIN (AsOf)
LOAD *,1 as YTD
RESIDENT (AsOf)
WHERE year(AsOfDate) = year(Date)
AND AsOfDate >= Date
;
LEFT JOIN (AsOf)
LOAD *
,if(quarterstart(AsOfDate)=quarterstart(Date),1) as QTD
,if(monthstart(AsOfDate)=monthstart(Date),1) as MTD
RESIDENT (AsOf)
;
Dimension = AsOfDate
YTD = sum({<YTD={1}>} Sales)
etc.
