10 Replies Latest reply: Jul 28, 2015 2:46 PM by kushal chawda RSS

    Many to Many relationship

    Mark Graham

      Hi,

       

      I have the below data.

       

      When i try to get data in table like,

       

      W2  SUm(Qty)

       

      i get error data when i drill down to SKU....It doesn't show individual SUm() but shows Total() as result in every field...

      Can anyone help me

       

       

      SKU     W1    Qty

      1          a          234

      2          b          4323

      1          c          32

      2          d          12

         

       

      SKU         W2          Location

      1          a                    22

      2              b          324

      1          c          4545

      2          d          231