Want Most recent completed week and trailing 11 periods or selected range

[sandeepprasad_j]

HI Experts ,

Presently i am using the expression below for getting the Trend for 6 months ,but by using the below expression i am not getting trailing 11 periods by chnaging the value in the expression

sum({<Year=,Weekly=,date_con ={'>=$(=addmonths(max(date_con),-11))<=$(=max(date_con))'},[Metric_ID] ={'PR_001'} >} Result)

SO Can anyone please help me in getting the trailing 11 period

Also Attaching the sample qvw for the reference

Thanks a ton in advance

Regards,

Sandeep.

[er_mohit]

Try this

sum({$<date_con = {">=$(=MonthStart(Max(date_con),-11))<=$(=MonthEnd(Max(date_con)))"},Year=,Weekly=,[Metric_ID] ={'PR_001'}>}Result)

[sandeepprasad_j]

Hi Mohit ,

Thanks for ur reply .

The expression which u have sent is not working ...

Can u please got through the attached qvw and help please

Thanks a ton in advance

Sandeep

[er_mohit]

see the attached application

[sandeepprasad_j]

The above qvw which u have sent is not resolving my issue . Can u use my qvw which i have attached.

thanks,

Sandeep.

[sandeepprasad_j]

Can anybody help on this