How to group and sum columns

[msuk121336387]

I have been trying for quite a while to get duplicate "Part Numbers" (ComponentItemNumber) to group and the "Picked" column to SUM up to one number. As shown below.

ComponentItemNumber	SRL	ItemDescription	Cost	Picked	OnHandQty	OnOrderQty	Source	Std_Price
201056756		BUSH C/S	£15.00	1	33	20	BL2	£38.42
201056756		BUSH C/S	£15.00	2	33	20	BL2	£38.42
201056756		BUSH C/S	£15.00	4	33	20	BL2	£38.42
201058600		BUSH	£24.60	1	5	5	BL1	£68.20
201058600		BUSH	£24.60	2	5	5	BL1	£68.20

This is what I want to achieve below.

ComponentItemNumber	SRL	ItemDescription	Cost	Picked	OnHandQty	OnOrderQty	Source	Std_Price
201056756		BUSH C/S	£15.00	9	33	20	BL2	£38.42
201058600		BUSH	£15.00	3	5	5	BL1	£68.20
201058689		SCREW	£24.60	10	20	40	BL0	£78.15

If anyone could help me i would appreciate it very much. Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Create a straight table, add all the fields except Picked as dimensions. Add sum (Picked) as expression. Reorder the columns to your liking.

[msuk121336387]

Thanks for the answer. I have created the straight table with all the fields and the expression, but the table is not populating any of the data. I might be being stupid but how do i get the straight table to populate.

Thanks in advance

[msuk121336387]

I was being stupid, i put the expression in the wrong place. Thanks for your help.