Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create a straight table, add all the fields except Picked as dimensions. Add sum (Picked) as expression. Reorder the columns to your liking.
Create a straight table, add all the fields except Picked as dimensions. Add sum (Picked) as expression. Reorder the columns to your liking.
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
I was being stupid, i put the expression in the wrong place. Thanks for your help.