Sum of december of Last Year and Variation of January this year

[#1]

Hello everyone,

I am try to write a formule to sum the value of december of Last Year and Variation of January this year, but I can't make it work.

Here's a simplified version:

I have a table like this

and I want to make the table below:

but with the formule I write :

=sum({<Year={$(=max(Year)-1)},Month=>}Sales) +sum({<Month={'janv.'}>}Variation)

I get 10 for January 2015 instead of 100+10=110

How should I modify the formula?

Thanks a lot!

[Gysbert_Wassenaar]

Set analysis won't work. The set is calculated at the chart level, not the row level. Try rangesum(above([Sales last year]),variation).

[#3]

Thanks for your reply, but once I used

=RangeSum(Above([Sales last year]),Variation)

my Jan. value is right, but not Feb. value:

Can you please advise ?

Thanks alot!