title: Aggregate other rows based on comparing dimension in Set Analysis
body: <p>I have data that looks like this:</p>
  
  <pre><code>Associate   ReferredBy  SalesQty    ReferralSales
  Alice       Bob         50
  Bob         Carl        60
  Carl        NULL        70
  Alice       NULL        80
  Bob         Alice       90
  Dan         Alice       10
  </code></pre>
  
  <p>In the <code>ReferralSales</code> column, I want to display the aggregate sales of the associate through referrals.</p>
  
  <p>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.</p>
  
  <p>How can this be achieved?  I have tried:</p>
  
  <pre><code>SUM({1 Associate = {ReferredBy}} SalesQty)
  </code></pre>