set analysis problem

[#1]

hi, my problem in when i select year=2014 and month=1, i want to get saleQty in year=2013 and month=1(last year current month saleQty). pls help

[MK_QSL]

SUM({<Year = {'$(=Max(Year)-1)'}>}saleQty)

[#3]

thanks manish. I missed the Max(). why we use Max() for that?

[MK_QSL]

In case if you have selected 2 or 3 years at a time, we need to tell set analysis that the calculation need to be based on Max Year from the selected.

[#5]

hi, the result is same as 2014. it s not changing to 2013

[#6]

No manish, i m only selecting one year at a time. then i want to get last year saleQty

[jagan]

Hi,

If you have date dimension then try like this

=Sum({<YearDimensionName=, QuarterDimensionName=, MonthDimensionName=,

DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -12))<=$(=MonthEnd(Max(DateDimensionName), -12))'}>} Sales)

Regards,

jagan.

[#8]

Hi jagan, I only have year and month. for an example when i select year=2014 and month=1, i want to get saleQty in year=2013 and month=1(last year current month saleQty). my fields are year, month, saleQty

[MK_QSL · Accepted solution]

Check enclosed file...

[#10]

thanks both of u