Topics started by pandeyb3
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)
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.