complex Aggregate function

[sam_nik12345]

Againt the forecast, I wish to aggregate to check available stock qty.

One is to find forecast and avilable matrl qty from table and 2nd is to find comp level avaivalility from table2.

Kindly help.

My tables look like below.

table1

forecast	matrl	fqty
111a	mat1	1
112a	mat2	1
113a	mat3	1
114a	mat4	1
115a	mat5	1
116a	mat6	1
117a	mat7	1
118a	mat8	1
119a	mat9	1
120a	mat10	1
121a	mat11	1
123a	mat12	1.000
124a	mat13	1.000

table2

matrl	equip	eqty
mat1	comp1	1
mat2	comp1	1
mat3	comp2	1
mat4	comp2	1
mat5	comp2	1
mat6	comp3	1
mat7	comp3	1
mat8	comp3	1
mat9	comp3	1
mat10	comp5	1
mat11	comp4	1
mat12	comp4	1
mat13	comp4	1

table3

forecast	Jan	feb	mar
111a	1	2	3
112a	1	2	3
113a	1	2	3

[Anonymous]

Hi @sam_nik12345 ,

Sorry, not very clear.

What do your expected results look like?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.