I'd like to calculate the "value" of a customer as the sum of all "value"s of customers they've referred -- essentially a pyramid (see the attached).

- In trying a simple self-join relationship with a sum calc, the value only goes 1 level deep.

- A "List" calc gives weird results.

Any suggestions?

Why 2nd level have sum as sum of

valueof children but 1st level have sum ofsum? Value of 2nd level is not used.