2 Replies Latest reply on Dec 5, 2016 7:11 AM by Jim Dehner

    Values are getting doubled after join

    Anjaneyulu Kottapalli

      Hi Friends,

       

      Attached the workbook with the values and the relation of the entities.

       

      I need to get the exact sum for the each order id  like for order id 1 sum(value ) =10 and for order id 2 sum(value) = 20 ....

       

      But when joined the order value is getting doubled as two customers shares the same order..

       

      Tried with the row number but no luck!

       

      Any suggestions ?