Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Topics started by pandeyb3

1 Topic

P
pandeyb3New Member
asked in LookML

Calculating Rollup Revenue

HiI 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
P
6 months ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service