1 Reply Latest reply on Aug 9, 2012 9:53 AM by Virginie Baronnet

    Calculated field that sums all records that have a same column value as current record?

    Nick Rosiello

      I am sure this has an elementary answer, but I have searched the forums for a few hours and could not find it.  Essentially, I have a data set with two columns, Factory Work Order and Parts Produced.  I would like to create a third calculated field, Total Parts in Factory Work Order, that sums the Parts Produced for all records that match the Factory Work Order of the current record.  An example of the finished data set:

       

      Factory Work OrderParts Produced
      Total Parts in Factory Work Order
      135
      249
      125
      259
      333

      I have also attached a workbook with this scenario.  Thank you for your help!