Calculate Previous Year Value in columns

[Mahabirpanigrahi]

HI Alteryx Experts, Need your help in calculating Previous Year Value in the column to the table. Have attached the data here, where i have shown my desired output in yellow color. I have tried a long process, thought checking with community for a better/easiest way to build this Appreciate in advance for help. Thanks Mahabir.

[Mahabirpanigrahi]

HI @Kamran1991,

You solution is just giving me the previous record value. While I am looking for the previous Yr value for the combination on the file. Example attached.