Logic help needed

[#1]

I have below data set.

ID	SubID	Actual
1	1	100
1	2	200
1	3	250
2	2	300
2	3	400
3	3	500
3	4	600

Output needed (I want to calculate it in front end only)

ID	Value
1	0
2	200
3	400

Logic: For ID 2, I want to see previous ID & subid should be equal to current id

          example, For ID 2, I will see the previous ID 1 and Pick subid =2 value

[vinieme12]

You can still use the Original solution which stalwar1‌ provided

Use Autonumber on your ID and SubID fields this will create number ID fields that you had originally provided and proceed with Sunny's solution

LOAD  *,AutoNumber(ID) as IDKey,AutoNumber(SubID) as SubIDKEY INLINE [

ID,SubID,Actual

AB12CD,AB12CD,100

AB12CD,TD123C,200

AB12CD,PC12KT,250

TD123C,TD123C,300

TD123C,PC12KT,400

PC12KT,PC12KT,500

PC12KT,KC123T,600

];