Set analysis sum

[josemaria_cabre]

Hi Everyone,

I have following Table:

My objective is to sum only items greater than Last Year. 

In this example, this would be items c,d,e and g and expected result is 42 (8+10+15+9).

I tried to accomplish this, using expression: 

=Sum({<ThisYear={'=ThisYear>LastYear'}>} ThisYear)

As you can see, item d is greater ThisYear than LastYear, but it doesn't appear in table. What am I doing wrong?

Thanks in advance for your help.

Jose.

[Gysbert_Wassenaar · Accepted solution]

Try: =Sum({<[item]={'=sum(ThisYear)>sum(LastYear)'}>} ThisYear)