5 Replies Latest reply: Jun 21, 2013 10:06 AM by Maxime Galichet RSS

    comparing different expression against different dimension...

    Maxime Galichet

      Hi All,

       

      It's Friday and it seems that my brain doesn't want to work anymore...

       

      i have the table below

      DimensionExpression
      YearTermABC
      2010T1646458
      2010T2665445
      2010T3514750
      2010T4606138
      2011T1616650
      2011T2596947
      2011T3495848

       

      I need to compare B in T2 2010 against A in T1 2010, C in T2 2010 against B in T1 2010 and so on...

       

      Any idea on how I should tacle that?

       

      I have set up a table where it give me the previous term compare to term n, but that doesn't seems to be the right route to take.

       

      I am looking forward to your assistance.

      Maxime