how to calculate ytd,mtd,qtd,lytd without using set analysis and with using if statement?

[sumitjadhav]

how to calculate ytd,mtd,qtd,lytd without using set analysis and with using if statement?

[swuehl]

You can look into using an As-Of-Table:

Calculating rolling n-period totals, averages or other aggregations