SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE T
	([id] int, [gooditem] varchar(5), [amt] int)
;
	
INSERT INTO T
	([id], [gooditem], [amt])
VALUES
	(1, 'apple', 1000),
	(2, 'apple', 2000),
	(3, 'apple', -3000),
	(4, 'apple', 500),
	(5, 'apple', 1500),
	(6, 'pen', 1000),
	(7, 'pen', 2000),
	(8, 'pen', -3000),
	(9, 'pen', 500),
	(10, 'pen', 1500)
;
10 rows affected

select * from t


id
gooditem
amt


1
apple
1000

2
apple
2000

3
apple
-3000

4
apple
500

5
apple
1500

6
pen
1000

7
pen
2000

8
pen
-3000

9
pen
500

10
pen
1500


    select id, gooditem, amt,
           (2000 - sum(amt) over (partition by gooditem order by id desc)) as total_amt
    from t


id
gooditem
amt
total_amt


5
apple
1500
500

4
apple
500
0

3
apple
-3000
3000

2
apple
2000
1000

1
apple
1000
0

10
pen
1500
500

9
pen
500
0

8
pen
-3000
3000

7
pen
2000
1000

6
pen
1000
0

id	gooditem	amt
1	apple	1000
2	apple	2000
3	apple	-3000
4	apple	500
5	apple	1500
6	pen	1000
7	pen	2000
8	pen	-3000
9	pen	500
10	pen	1500