Calculating Rollup Revenue

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)
0 0 295
0 REPLIES 0
Top Labels in this Space
Top Solution Authors