2 Replies Latest reply: May 24, 2016 11:51 PM by michael tamsil RSS

    get sum value from SAPCode that have it to each suppliers & group by supplier

    michael tamsil

      Hi All,

       

      i want to ask something from my problem.

      i want to get sum value from SAPCode that have it to each suppliers and group by supplier.

      for data  sample

      table.png

      and want to get the result

      result.png

       

      currently i've get the list SAPCode that matched for each supplier and only 2

      list sapcode that matches.png

      with editor expression and use variable

      Aggr(if ($(var_CountGroupBySupplier) = $(var_TotalSupplierBaseOnSAPCode), SAPCode), SAPCode)

       

       

      variable var_CountGroupBySupplier  =    Count(   Supplier )

      variable var_TotalSupplierBaseOnSAPCode = Count( distinct  TOTAL Supplier)

       

       

      and for count match SAPCode that is matched  is 2,

      count sapcode that matched.png

      how i can get sum value from SAPCode that have it to each suppliers and group by supplier?