If you use a FULL JOIN instead of the LEFT JOIN, it should include even 'Only in Account' row.

Awesome!!!. This is exactly what I want

Thanks a lot.

Hi

I currently have a hierarchy report (using the Recursive functionality) with multiple levels that is a drill down from the top (parent) to bottom. Here is what I have right...