month YTD vs Month lastyr

[#1]

Hi Experts,

i have the following expression in a chart.

Expr 1

=sum({<DEC_WeekStart = {">=$(=Weekstart(today(),-12,$(vCal_FD)))<=$(=weekstart(today(),0,$(vCal_FD)))"}>} sales)

Expr 2

=sum({<DEC_WeekStart = {">=$(=Weekstart(addyears(today(),-1),-12,$(vCal_FD)))

=$(=weekstart(addyears(today(),-1),0,$(vCal_FD)))"}>}sales)

these two expressions deals with the calculation of sales value for recent 12 weeks of this yr and the same for prev year.

($(vCal_FD) is the variable to make the weekstart as saturday)

Now, i need to calculate the monthly figures for this yr and prev yr like the same above expressions.

the graph for weeks performance is attached below.

like this, i need to provide the monthly performance.

how can i do this.

pls help.

[Gysbert_Wassenaar]

In your chart replace the DEC_WeekNumber dimension with your Month dimension.

[MK_QSL · Accepted solution]

May be,

=SUM({<Date = {">=$(=MonthStart(Today()),-11)<=$(=MonthEnd(Today()))"}>}sales)

and

=SUM({<Date = {">=$(=MonthStart(AddYear(Today(),-1)),-11)<=$(=MonthEnd(AddYear(Today(),-1)))"}>}sales)

Also use, Month=, Year=, Quarter to bypass

[#4]

thank u manish