2 Replies Latest reply: Apr 15, 2010 12:56 PM by Pablo_Parnisari RSS

    Help needed with a set analisys !!

    Pablo_Parnisari

      Hi:

      I'm trying to make a simple bar chart with X=time dimension (years) and Expression = Difference between "Sales Current Year - Sales Previous Year".

      By example:

      year 2000 --------> Sales $100

      year 2001 --------> Sales $250

      year 2002 --------> Sales $600

      So I want get for:

      year 2001 -------> $150 ($250 -$100)

      year 2002 -------> $350 ($600-$250)

      and so on...

      I´ve tried with this set expression:

       

      sum([Sale]) - sum({$<Year={$(#Year -1 )} > }[Sale])


      but $(#Year -1 ) becomes in a empty string or in some cases (lightly variants) in 0 (zero).

      Could any help me !

      Very thankful