8 Replies Latest reply: Nov 27, 2017 6:57 AM by Sunny Talwar RSS

    Sum of Filed on a condition of different field ?

    gaurav gopale

      Hi All

       

      I want to sum the Volume who has Max Price group by Material Vendor combination and show in KPI

       

       

      For example

      I have the following table

       

      MaterialVendorPriceVolume
      1A10100
      1A20200
      2B40300
      2B50400

       

       

      Expected Output  in KPI .

       

       

      For Material 1 and Vendor A  the max price is 20 , so we have to consider 200 as Volume for that Material Vendor Combination

       

      same goes for

      Material 2 and Vendor 2 the max price is 50 , so we have to consider 400 as Volume for that Material Vendor Combination



      So , in kpi  the value should show 600


      200 + 400 = 600



      Can anyone help me in this ?

       

      Thanks in Advance

       

       

      Regards

      Gaurav Gopale