last year data in Qlik Sense using expression

[vanand3535]

Hi all,

I need to find the Sales in prior season .

Season= 2013,2014,2015,2016,2016

Logic :-

Prior season sales(2016)=  total sales(2013,2014,2015)

Prior season sales(2015)=total sales(2013,2014)

same for others...

How can I do this?

[vanand3535]

just now i have attached screenshots of the original data please check that