Creat Sum Last year in standard table

[#1]

Dear Qlik users,

How can i get the sum last year data in the green marked zone?

Thanks for all your help.

[jolivares]

In this case you have to disregard the year selected, just for experience what is happens, try to make a table with just year and sales.  Your expressions are: Year (dim) and Sum(Sales) (exp).

But try this ones: Year (dim) and Sum({<Year>}Sales) (exp).

You see now, this is set analysis.