Getting previous value against a category and subcategory
Got struck in one task wherein i want to fetch previous fiscal year month end value against each Finance LOB and Claim Type.
For ex:- Finance LOB = MOTOR-2W and Claim Type = OD and as mentioned in the attached excel Retension Loss for FY 2016 and Month =12 (March) is 100 and that value 100 should get applied on each month in the next fiscal year i.e FY 2017 Apr till FY 2017 Mar.
Similarly for FY 2018 Apr - FY 2018 Mar Fiscal year 2017 value of 200 should get applied in FY 2018 Apr till FY 2018 Mar.
Expected Output is also specified in the attached excel.
I tried using peek and previous function but not able to get the value against each Finance LOB and Claim Type i.e OD or TP