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|