12 Replies Latest reply: Dec 4, 2017 7:08 AM by Munetsi Danga RSS

    Sum of Rows

    Munetsi Danga

      Hi Community

       

      I have rows of data for an item but from different sales orders

      Since the item description is the same, i want one line (in a straight or pivot table)  that will give me the a total sum for this itemSumRows.JPG

      The correct quantity for the above should be 36

       

      May you please help  on how i can have something like (Using a calculation)

       

      BOMITEM_Description                    TOTALQUANTITY

      Zipper Bag                                  36