2 Replies Latest reply: Dec 16, 2011 2:02 PM by javierortiz RSS

    Set Analysis expresion into another Set Analysis Expresion

      Hi everybody, I have my sales defined like this:
      SALES Expresion:
      sum  ({$<INFOTYPE={'REAL'}>}[SALES MXN]/TC)/1000+sum({$<INFOTYPE={'UM6'}>}[SALES MXN]/TC)/1000
      and I want to use my sales to get last year sales:
      LAST YEAR Expresion
      sum ({$<Year = {$(=only(Year) - 1) }, Month = {"<=$(=max(Month))"}>} Sales)
      is just replacing my SALES Expresion into LAST Year Expresion?
      is there any way to get this working?