5 Replies Latest reply: Jun 18, 2012 7:39 AM by Revlin Abbi RSS

    Set analysis with a variable

      Hi all

      Using set analysis, basic example below:

      =sum({$ < Year={2007} >} Sales)

      However, what I would like to do is instead of having the 2007 as an actual value I would like it to be based
      on the value of a variable say called var_year.


      I have tried:

      =sum({$ < Year={var_year} >} Sales)


      and I have tried:

      =sum({$ < Year= var_year >} Sales)

      But no luck. Any idea on how I can get this to work?