I have data that looks like this:
Associate ReferredBy SalesQty ReferralSales
Alice Bob 50
Bob Carl 60
Carl NULL 70
Alice NULL 80
Bob Alice 90
Dan Alice 10
In the ReferralSales
column, I want to display the aggregate sales of the associate through referrals.
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.
How can this be achieved? I have tried:
SUM({1 Associate = {ReferredBy}} SalesQty)
If you wish to show the RefferalSales in the same table then just add to your script:
In the RefferalSales calc use:
sum(ReferredByQty)
and then you'll easily get