How can I calculate current 1 year in Tableau

Question

Show calculations for current as well as previous year,how to apply this dynamically?

It is getting possible if the year is written manually but it will be only temporary solution, how to do that dynamically?

i.e on applying filter Year=2013 then sales and orders value of current-1 year should be displayed I have sales and orders On the Columns.

Answer 1

A quick solution to this would be to create a new calculated field for previous year sales by using the Lookup function.

For example:

LOOKUP(SUM([SALES]),-1)