i want sum of sales for MOM and QOQ pls tell me how to write using setanalysis

[#1]

i want sum of sales for  MOM  and  QOQ pls tell me how to write using setanalysis

[Anonymous]

Month over Month:

sum({$<Year=,Quarter=,Month=>} if(InMonthToDate(Date,today(),0),Sales))

/

sum({$<Year=,Quarter=,Month=>} if(InMonthToDate(Date,today(),-1), Sales))

Quarter over Quarter is the same, only use InQuarterToDate() instead of InMonthToDate