6 Replies Latest reply: Aug 12, 2016 4:10 PM by KHOA NGUYEN RSS

    Sum other rows based on dimension compare

    KHOA NGUYEN

      I've got data that looks like this:

       

      AssociateReferredBySalesQtyReferredSalesQty
      AliceBob50100
      BobCarl6050
      CarlNULL7060
      AliceNULL80100
      BobAlice9050
      DanAlice100

       

      In the `ReferredSalesQty` column, I want to display the SUM of SalesQty they have referred.  So,

       

      Alice is responsible for referring Bob and Dan, resulting in 100 units of sales.

      Bob referred Alice, 50 units.

      Carl referred Bob, 60 units.

      Dan referred no one.

       

      Is this possible with Set Analysis?  I have tried

       

          SUM({1 Associate = {ReferredBy}} SalesQty)