I have a situation where I have cell which needs to be a reference of
another cell from the same dimension. The cell that needs the
reference will always be leaf but the cell reference that its trying to
get a data value can be leaf or aggregate. After the cells are
referenced then they have to rollup. What is the elegant way implement
this in the calc scripts?