1 Reply Latest reply: Sep 4, 2015 4:27 PM by Sunny Talwar RSS

    sum values on table

    rafael scalabrin

      Hello, I have, for example, a xls like this:

           

      customercustomer IDCompanySupplier Suplier IDValue
      Kurt1AAAKmart1200
      Kurt1AAAKmart1300
      Kurt1AAAKmart1300
      Kurt1AAAKmart1300
      Kurt1AAAKmart1300
      Kurt1AAAGmart2150
      Kurt1AAAHmart323
      Kurt1AAAJmart450
      Dave2AAAKmart110
      Dave2AAAGmart210
      Dave2AAAHmart310
      Dave2AAAJmart410
      Chris3BBBKmart150
      Chris3BBBGmart250
      Chris3BBBHmart3

      50

       

      and I need to put this in a table like this:

           

      Supplier Suplier IDDiferent CustomersDifferent CompaniesTotal
      Kmart1321460
      Gmart232210
      Hmart33283
      Jmart42160

       

       

      How can I do it, Im trying in a dinamic table, but couldnt figure it out, how can I do all the sum.

       

      Thanks.