All SKUs are already sorted as a query from different tables , I just want to add one additional line at the end of multiple/ similar products which will show sum of Sys Qty, Act qty, Vari & Total cost as below in sample data. Thanks SKU Sys Qty Act Qty Vari $ Unit Cost Total Value 19992319 1390 1298 -92 10.3082 -948.3544 19992319 384 392 8 10.3082 82.4656 1774 1690 -84 -865.8888 19996849 10 0 -10 23.3066 -233.066 19996849 305 412 107 23.3066 2493.8062 315 412 97 2260.7402 19912756 2064 2065 1 0.139 0.139 19917437 57 80 23 284.1799 6536.1377 19917437 431 467 36 69.4268 2499.3648 19917437 302 392 90 69.4268 6248.412 790 939 149 15283.9145 19912758 2064 2065 1 0.139 0.139 19917541 2064 2065 1 0.139 0.139 19912000 2064 2065 1 0.139 0.139

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Power Query : Sum of similar SKU/Products Lines

Thread starter srehman
Start date May 5, 2021

srehman

Board Regular

May 5, 2021

All SKUs are already sorted as a query from different tables , I just want to add one additional line at the end of multiple/ similar products which will show sum of Sys Qty, Act qty, Vari & Total cost as below in sample data. Thanks

SKU	Sys Qty	Act Qty	Vari	$ Unit Cost	Total Value
19992319	1390	1298	-92	10.3082	-948.3544
19992319	384	392	8	10.3082	82.4656
	1774	1690	-84		-865.8888
19996849	10	0	-10	23.3066	-233.066
19996849	305	412	107	23.3066	2493.8062
	315	412	97		2260.7402
19912756	2064	2065	1	0.139	0.139
19917437	57	80	23	284.1799	6536.1377
19917437	431	467	36	69.4268	2499.3648
19917437	302	392	90	69.4268	6248.412
	790	939	149		15283.9145
19912758	2064	2065	1	0.139	0.139
19917541	2064	2065	1	0.139	0.139
19912000	2064	2065	1	0.139	0.139