In order to facilitate testing we have set up the release candidate online at:
Folks –
I note you are using two tables to help you navigate through the org tree. Here is an SQL-friendly way of representing trees I learned some years ago from Joe Celko. I think this might make the aggregation task a lot simpler.
Regards, Roger