Calculate difference since set year

[martyn_birzys]

Hi guys, I need to calculate the increase/decrease every year compared to 2012.

The field expression I am using is:  Sum("Passenger Count")  - Sum({<[Year]={'2012'} >}"Passenger Count")

The result only correctly calculates 2012:  69-69=0. The other years show actual Passenger count, not the increase/decrease. Where am I going wrong with this?

[sunny_talwar · Accepted solution]

Try this

Sum("Passenger Count")  - Sum(TOTAL {<[Year]={'2012'} >}"Passenger Count")