Last Year Sales doesn't work

[shatrix]

Hi

Selected year sales is  : 

Sum({< Year={$(=max(Year))}>}QTY_KG)

returns the right values , works fine. 

While last year sales is :

Sum({<Year= {$(=max(year)-1)}>}QTY_KG)/1000

It only displays the current year QTY_KG !

Both lines return the same values !

How can I  fix that ? What's wrong with the syntax ?

[menta]

Check the Year and year.

Check if you use selections or dimension in table like year-month

[shatrix]

Tried year and Year . the same.

I don't use dimensions in table like year month, just customer name. 

What do you mean if I use selections ? Year is selected (happens with every year I select).