Indirect set analysis

[Anonymous]

Hi all,

I need to create a set analysis.

Suppose I have 2 years in my data base, 2012 and 2013.

I have a pivot table and I have a set analysis like this:

Sum({<YEAR={'$(=max(YEAR))'}>} QTY)

so, I have the quantity for year 2013 and month gen-feb-mar-apr-may-jun-jul-aug-sep (because we're in 2013 sept.)

Now i need a set analysis that calculate the amount of last year (Sum({<YEAR={'$(=max(YEAR)-1)'}>} QTY))  but only for the months excluded from the current selection: year 2012 months oct-nov-dec

Is it possible? I tought about indirect set analysis but I'm not able to write a correct formula.

How can I do that?

Thank you very much!

[michael_maeuser]

just create a variable vTest= month(today()) and add to your expression for previous year Month={'>=$(vTest)'}

[Gysbert_Wassenaar]

See attached example.