Show Previous year sale data corresponding current year

[panipat1990]

Dear Team,

Kindly help me for solving this problem.i stuck this requirmnet. i tried many times. but i didnot reach.Kindly help me.

For this i am sharing data.

REQUIRMENT IS SHOWING IN TABLE

Year	Sum(Sale)	Previous Year Sale	Header 4
2014	2200	Means 2013 Year Sale
2015	2500	2014 Sale means 2200
2016	2600	2015 Sale Means 2500
2017	2700	2600
2018	2800	2700

[sunny_talwar · Accepted solution]

Something like this?

Expression for previous year

=Above(Sum({<Year>}Sale)) * Avg(1)

[Anil_Babu_Samineni]

How about this?

Above(Sum(Sale)) * Avg(1)