Help needed with a set analisys !!

[#1]

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

[#2 · Accepted solution]

Hi,

try this:

Sum(Sale)-above(Sum(Sale))

Alex

[#3]

Perfect !!!

Clearly this is the easyest way!

Thankful!

Pablo