3 Replies Latest reply: Jan 9, 2013 2:19 AM by Daniel Doheny RSS

    How to group and sum columns

    Daniel Doheny

      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.

       

      ComponentItemNumberSRLItemDescriptionCostPickedOnHandQtyOnOrderQtySourceStd_Price
      201056756BUSH C/S£15.0013320BL2£38.42
      201056756BUSH C/S£15.0023320BL2£38.42
      201056756BUSH C/S£15.0043320BL2£38.42
      201058600BUSH£24.60155BL1£68.20
      201058600BUSH£24.60255BL1£68.20

       

      This is what I want to achieve below.

       

      ComponentItemNumberSRLItemDescriptionCostPickedOnHandQtyOnOrderQtySourceStd_Price
      201056756BUSH C/S£15.0093320BL2£38.42
      201058600BUSH£15.00355BL1£68.20
      201058689SCREW£24.60102040BL0£78.15

       

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