Hi
I am trying to calculate the rollup revenue in looker, I have multiple levels of hierarchy so the Revenue should roll up to the highest level. For Parent child relation we have parent account id in child account. I have table below for an example as to how I want data. Alphabets in table below are the hierarchy structure, Roll up revenue is sum of Direct Revenue.
| Direct Revenue | Rollup Revenue | ||||
|---|---|---|---|---|---|
| A | 275 | sum(A,B,C,D,E,F,G,H,I,J,K) | |||
| B | 250 | sum(B) | |||
| C | 225 | sum(C,D) | |||
| D | 200 | sum(D) | |||
| E | 175 | sum(E) | |||
| F | 150 | sum(F,G,H,I,J,K) | |||
| G | 125 | sum(G) | |||
| H | 100 | sum(H) | |||
| I | 75 | sum(I,J,K) | |||
| J | 50 | sum(J) | |||
| K | 25 | sum(K) |