MySQL 8.0

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

CREATE TABLE tbl ( region VARCHAR(60), type VARCHAR(10), month TINYINT, amount INT );
INSERT INTO tbl VALUES
  ('USA', 'Apple',  1, 10),
  ('USA', 'Apple',  2, 20),
  ('USA', 'Apple',  3, 10),
  ('USA', 'Apple',  4, 20),
  ('USA', 'Apple',  5, 10),
  ('USA', 'Apple',  6, 10),
  ('USA', 'Apple',  7, 10),
  ('USA', 'Apple',  8, 20),
  ('USA', 'Apple',  9, 10),
  ('USA', 'Apple', 10, 20),
  ('USA', 'Apple', 11, 20),
  ('USA', 'Apple', 12, 10),
  ('Europe', 'Orange',  1, 10),
  ('Europe', 'Orange',  2,  5),
  ('Europe', 'Orange',  3,  5),
  ('Europe', 'Orange',  4,  5),
  ('Europe', 'Orange',  5,  5),
  ('Europe', 'Orange',  6, 20),
  ('Europe', 'Orange',  7, 20),
  ('Europe', 'Orange',  8, 20),
  ('Europe', 'Orange',  9, 20),
  ('Europe', 'Orange', 10, 10),
  ('Europe', 'Orange', 11, 10),
  ('Europe', 'Orange', 12,  5);

Records: 24  Duplicates: 0  Warnings: 0


select 
    region, type, month, amount,
    sum(amount) over (partition by region, type) -
    sum(amount) over (partition by region, type order by month asc) as amt
from tbl
order by region desc, type asc, month asc


region
type
month
amount
amt


USA
Apple
1
10
160

USA
Apple
2
20
140

USA
Apple
3
10
130

USA
Apple
4
20
110

USA
Apple
5
10
100

USA
Apple
6
10
90

USA
Apple
7
10
80

USA
Apple
8
20
60

USA
Apple
9
10
50

USA
Apple
10
20
30

USA
Apple
11
20
10

USA
Apple
12
10
0

Europe
Orange
1
10
125

Europe
Orange
2
5
120

Europe
Orange
3
5
115

Europe
Orange
4
5
110

Europe
Orange
5
5
105

Europe
Orange
6
20
85

Europe
Orange
7
20
65

Europe
Orange
8
20
45

Europe
Orange
9
20
25

Europe
Orange
10
10
15

Europe
Orange
11
10
5

Europe
Orange
12
5
0


select *,
    ifnull(sum(amount) over (
        partition by region, type
        order by month desc
        rows between unbounded preceding and 1 preceding
    ), 0) as amount
from tbl
order by region desc, type asc, month asc


region
type
month
amount
amount


USA
Apple
1
10
160

USA
Apple
2
20
140

USA
Apple
3
10
130

USA
Apple
4
20
110

USA
Apple
5
10
100

USA
Apple
6
10
90

USA
Apple
7
10
80

USA
Apple
8
20
60

USA
Apple
9
10
50

USA
Apple
10
20
30

USA
Apple
11
20
10

USA
Apple
12
10
0

Europe
Orange
1
10
125

Europe
Orange
2
5
120

Europe
Orange
3
5
115

Europe
Orange
4
5
110

Europe
Orange
5
5
105

Europe
Orange
6
20
85

Europe
Orange
7
20
65

Europe
Orange
8
20
45

Europe
Orange
9
20
25

Europe
Orange
10
10
15

Europe
Orange
11
10
5

Europe
Orange
12
5
0

region	type	month	amount	amt
USA	Apple	1	10	160
USA	Apple	2	20	140
USA	Apple	3	10	130
USA	Apple	4	20	110
USA	Apple	5	10	100
USA	Apple	6	10	90
USA	Apple	7	10	80
USA	Apple	8	20	60
USA	Apple	9	10	50
USA	Apple	10	20	30
USA	Apple	11	20	10
USA	Apple	12	10	0
Europe	Orange	1	10	125
Europe	Orange	2	5	120
Europe	Orange	3	5	115
Europe	Orange	4	5	110
Europe	Orange	5	5	105
Europe	Orange	6	20	85
Europe	Orange	7	20	65
Europe	Orange	8	20	45
Europe	Orange	9	20	25
Europe	Orange	10	10	15
Europe	Orange	11	10	5
Europe	Orange	12	5	0