SQL Server 2022

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

Create table aa (
YYMM NVARCHAR(5),
X1 NVarchar(10),
X2 NVarchar(10),
X3 NVarchar(10),
X4 Float);

Insert Into aa Values
('11304','B','02',N'螺絲-全',1300),
('11304','B','02',N'螺絲-次',5),
('11304','A','02',N'螺絲-次',4),
('11304','A','02',N'螺絲-全',1200),
('11304','A','01',N'螺絲-次',2),
('11304','A','01',N'螺絲-全',1000),
('11304','B','01',N'螺絲-次',3),
('11304','B','01',N'螺絲-全',1100),

('11305','B','02',N'螺絲-全',1300),
('11305','B','02',N'螺絲-次',15),
('11305','A','02',N'螺絲-次',14),
('11305','A','02',N'螺絲-全',1200),
('11305','A','01',N'螺絲-次',12),
('11305','A','01',N'螺絲-全',1000),
('11305','B','01',N'螺絲-次',13),
('11305','B','01',N'螺絲-全',1100);

Select * From aa
Order By YYMM,X2,X1,X3 desc;


YYMM
X1
X2
X3
X4


11304
A
01
螺絲-次
2

11304
A
01
螺絲-全
1000

11304
B
01
螺絲-次
3

11304
B
01
螺絲-全
1100

11304
A
02
螺絲-次
4

11304
A
02
螺絲-全
1200

11304
B
02
螺絲-次
5

11304
B
02
螺絲-全
1300

11305
A
01
螺絲-次
12

11305
A
01
螺絲-全
1000

11305
B
01
螺絲-次
13

11305
B
01
螺絲-全
1100

11305
A
02
螺絲-次
14

11305
A
02
螺絲-全
1200

11305
B
02
螺絲-次
15

11305
B
02
螺絲-全
1300


Select *
From (
Select YYMM,X1,X2,X3,X4 
From aa
Union 
Select T1.YYMM,T1.X1 AS X1,T1.X2 AS X2,N'螺絲-率' AS X3,
Round(T1.X4 / T2.X4,6) AS X4
From aa AS T1  
Left Join aa AS T2 On T1.X1 = T2.X1 And T1.X2 = T2.X2  And T1.YYMM = T2.YYMM
Where T1.X3 = N'螺絲-次'
And T2.X3 = N'螺絲-全') AS MM
--
Order By YYMM,X2,X1,(Case When X3 = N'螺絲-次' then 1
                     When X3 = N'螺絲-全' then 2
                     When X3 = N'螺絲-率' then 3
                     Else 4 End)


YYMM
X1
X2
X3
X4


11304
A
01
螺絲-次
2

11304
A
01
螺絲-全
1000

11304
A
01
螺絲-率
0.002

11304
B
01
螺絲-次
3

11304
B
01
螺絲-全
1100

11304
B
01
螺絲-率
0.002727

11304
A
02
螺絲-次
4

11304
A
02
螺絲-全
1200

11304
A
02
螺絲-率
0.003333

11304
B
02
螺絲-次
5

11304
B
02
螺絲-全
1300

11304
B
02
螺絲-率
0.003846

11305
A
01
螺絲-次
12

11305
A
01
螺絲-全
1000

11305
A
01
螺絲-率
0.012

11305
B
01
螺絲-次
13

11305
B
01
螺絲-全
1100

11305
B
01
螺絲-率
0.011818

11305
A
02
螺絲-次
14

11305
A
02
螺絲-全
1200

11305
A
02
螺絲-率
0.011667

11305
B
02
螺絲-次
15

11305
B
02
螺絲-全
1300

11305
B
02
螺絲-率
0.011538


Select *
From (
Select YYMM,X1,X2,X3,X4 
From aa
Union 
Select T1.YYMM,T1.X1 AS X1,T1.X2 AS X2,N'螺絲-率' AS X3,
Round(T1.X4 / T2.X4,6) AS X4
From aa AS T1  
Left Join aa AS T2 On T1.X1 = T2.X1 And T1.X2 = T2.X2  And T1.YYMM = T2.YYMM
Where T1.X3 = N'螺絲-次'
And T2.X3 = N'螺絲-全') AS MM
--
PIVOT ( 
SUM(X4) 
FOR X2 IN ([01],[02]) 
) AS QQ
Order By YYMM,X1,(Case When X3 = N'螺絲-次' then 1
                  When X3 = N'螺絲-全' then 2
                  When X3 = N'螺絲-率' then 3
                  Else 4 End)


YYMM
X1
X3
01
02


11304
A
螺絲-次
2
4

11304
A
螺絲-全
1000
1200

11304
A
螺絲-率
0.002
0.003333

11304
B
螺絲-次
3
5

11304
B
螺絲-全
1100
1300

11304
B
螺絲-率
0.002727
0.003846

11305
A
螺絲-次
12
14

11305
A
螺絲-全
1000
1200

11305
A
螺絲-率
0.012
0.011667

11305
B
螺絲-次
13
15

11305
B
螺絲-全
1100
1300

11305
B
螺絲-率
0.011818
0.011538

YYMM	X1	X2	X3	X4
11304	A	01	螺絲-次	2
11304	A	01	螺絲-全	1000
11304	B	01	螺絲-次	3
11304	B	01	螺絲-全	1100
11304	A	02	螺絲-次	4
11304	A	02	螺絲-全	1200
11304	B	02	螺絲-次	5
11304	B	02	螺絲-全	1300
11305	A	01	螺絲-次	12
11305	A	01	螺絲-全	1000
11305	B	01	螺絲-次	13
11305	B	01	螺絲-全	1100
11305	A	02	螺絲-次	14
11305	A	02	螺絲-全	1200
11305	B	02	螺絲-次	15
11305	B	02	螺絲-全	1300