Set Analysis -- LastYear/LastMonth

[#1]

Hi...

I would like when I click on Year on my selection List Sum Qty for year = Year-1  and Month = Month(Max(Month)-1)

Example : I clik on Year = 2012 [2011 -- NOV.] (selection list)

I obtain a calculation like : Sum (Qty) for {Year=2011;nov.} in dynamic.

[lironbaram]

hi

for the whole last year  use

sum({<Year={"$(=max(Year)-1)"}, Month=>} Qty)

for same month in last year use

sum({<Year={"$(=max(Year)-1)"}>} Qty)

[CELAMBARASAN]

Hi,

     Use set analysis for this type of problem.

     =Sum({<Year={$(=Max(Year)-1)},Month={'$(=if(GetSelectedCount(Month)>0,Month(AddMonths(Max(Date),-1)),'*'))'}>} Qty)

Hope it helps

Celambarasan

[#4]

Thank you. I'll test it !!