Grouping & Sum by Row, Table, Straight Table.

[bnelson111]

I have a table box as per below with no calculations.

Shipped Qty	Shipped Item Area	Shipped Item Code	Ship Req	Month Shipped	Sales Order	Customer Code	SoOderLine.Unit	Cust
3,012,904	0.00982	50577	230272	Sep	190918-1	100331	0.0038	2
2,147,140	0.00679	16383	230155	Sep	193438-1	100005	0.00153	2
2,091,500	0.00679	16382	229715	Sep	192088-1	100005	0.00153	2
1,972,390	0.01080	15253	230235	Sep	188006-1	100382	0.00226	3
1,966,500	0.01779	50435	230314	Sep	192321-1	100353	0.00288	4
1,764,851	0.00945	13700	230086	Sep	188127-1	100235	0.0014	5
1,484,840	0.00594	18544	230236	Sep	190207-1	100307	0.00098	2
1,349,200	0.00731	13910	230274	Sep	189507-1	100005	0.00207	2
1,322,540	0.00987	18743	230449	Sep	192428-1	100307	0.00112	3
1,247,400	0.00817	18332	230233	Sep	191003-1	100364	0.00148	3
1,194,264	0.01071	18844	230449	Sep	192583-1	100307	0.00135	4
1,175,940	0.01095	18935	230366	Sep	193585-1	100235	0.0021	1

What I'm attempting to do is perform a calculation per row in this case sales order row. Sum is (Shipped Qty) * (Shipped item Area). If i do this in straight table using sales order as dimension with following calculation "sum(ConfirmedShippedQty)*sum([Item Table.AREALABEL])" no worries all okay but i want it by cust, problem is each line needs equation performed. Don't want to use pivot table.

Any ideas.

Thanks in advance. Brett

[sunny_talwar · Accepted solution]

Try this may be

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

[bnelson111]

Thats been busting my head, simple. Feel embarrassed now. Thank you.