2 Replies Latest reply: Sep 3, 2013 8:52 AM by Gysbert Wassenaar RSS

    Indirect set analysis

    Giorgia Michieli

      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!