morning guys

[#1]

can any one help:

is there anything wrong with the following expression:

• Sum({$<MonthID = {“<=$(=Max(MonthID))”}, Year = {$(=Max(Year))}, Quarter = , Month = >} Sales)

[#2]

Hi Guys

I am using the expression below to get (prev ytd(01-01-2014 to 19-01-2014))data but somehow is giving me everything from 01-01-2014 to 01-01-2015....below is the expression and same thing apply to LQTD(01-01-2014 to 19-01-2014),LMTD(01-12-2014 to 19-12-2014), PriorYear_MTD(01-01-2014 to 19-01-2014) LWTD(11-01-2015 to 12-01-2015) and PRIOR_WTD(19-01-2014 to 19-01-2014) but to all field is returning everything from the start date till yesterday

.......... LQTD

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(QuarterStart(Max(DateNum), -4)))<=$(=AddYear(Max(DateNum), -1))"}>} Sales)    

LMTD

Sum({<Year=, Month=, Quarter=, WeekOfYear=, Date_Dt=, DateNum={">=$(=Num(MonthStart(Max(DateNum),-12)))<=$(=AddYear(Max(DateNum),-1))"}>} Counter_Num)

PRIOR_YEAR_MTD

Sum({<Year=, Month=, Quarter=, WeekOfYear=, Date_Dt=, DateNum={">=$(=Num(MonthStart(Max(DateNum), -12)))<=$(=AddYear(Max(DateNum), -1))"}>} Counter_Num)

LWTD:

Sum({<Year=, Month=, Quarter=, WeekOfYear=, Date_Dt=, DateNum={">=$(=Num(WeekStart(Max(DateNum), -52)))<=$(=AddYear(Max(DateNum), -1))"}>} Counter_Num)

PRIOR_YEAR_WTD:

Sum({<Year=, Month=, Quarter=, WeekOfYear=, Date_Dt=, DateNum={">=$(=Num(WeekStart(Max(DateNum), -52)))<=$(=AddYear(Max(DateNum), -1))"}>} Counter_Num)

help me guys