Hi
Current season is summer 2018.
With below expression, it returns the value for same time LY.
I need it to return summer 2017.
if(Wildmatch($(ObjectList),'*Week*'), Sum({<Year = {$(vMinYear)}>} [Cls Stk Value]),if(Wildmatch($(ObjectList),'*Month*'), Sum({<Year, $(vClearDates),[SK LDOW No] = P({<[SK Ldom No] -= {$(vMaxLdowLdomPrevious)}>} [SK Ldom No])+{$(vCurrentMonthLdowPrevious)} >} [Cls Stk Value]),if(Wildmatch($(ObjectList),'*Season *'), Sum({<Year, $(vClearDates), [SK LDOW No] = P({<[Numeric Yr Ssn Code] -= {$(vMaxPrevSsnCode)}>}SeasonEndLdow)+{$(vMaxLdowPrevious)} >} [Cls Stk Value]),if(Wildmatch($(ObjectList),'*Year*'), Sum({<Year, $(vClearDates), [SK LDOW No] = P({<Year -= {$(vMinYear)}>}YearEndLdow)+{$(vMaxLdowPrevious)} >} [Cls Stk Value]),Sum({<Year, $(vClearDates), [SK LDOW No] = {$(vMaxLdowPrevious)} >} [Cls Stk Value])))))
+
if(Wildmatch($(ObjectList),'*Week*'), Sum({<Year = {$(vMinYear)}>} [In Trnst Value]),if(Wildmatch($(ObjectList),'*Month*'), Sum({<Year = {$(vMinYear)}, $(vClearDates),[SK LDOW No] = P({<[SK Ldom No] -= {$(vMaxLdowLdomPrevious)}>} [SK Ldom No])+{$(vCurrentMonthLdowPrevious)} >} [In Trnst Value]),if(Wildmatch($(ObjectList),'*Season *'), Sum({<Year = {$(vMinYear)}, $(vClearDates), [SK LDOW No] = P({<[Numeric Yr Ssn Code] -= {$(vMaxPrevSsnCode)}>}SeasonEndLdow)+{$(vMaxLdowPrevious)} >} [In Trnst Value]),if(Wildmatch($(ObjectList),'*Year*'), Sum({<Year = {$(vMinYear)}, $(vClearDates), [SK LDOW No] = P({<Year -= {$(vMinYear)}>}YearEndLdow)+{$(vMaxLdowPrevious)} >} [In Trnst Value]),Sum({<Year = {$(vMinYear)}, $(vClearDates), [SK LDOW No] = {$(vMaxLdowPrevious)} >} [In Trnst Value])))))
