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) |