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 ?