Pplog,
When, I use your queries, I am getting the same total at each level. How are the revenues at the intermediate levels added to the totals? It seems that each query is just bringing up the lowest level's (0 level) totals.
Thanks
Eager to become an active participant!
101-02-URVJCCC50D-DZEHP01465-zyd03mTZJQdxD0LfzXmsrbj0yPZVkuVjpeU8JcP2M
DtJt95pV_DP44vuvEvrfNXWxEPA6sjnh765pH0hDw5reZ9qBqQd7a/yVk/elZ1jsQpPb7E
ZTMQzX7JhXP_HxD1O4QODoIiVJ_/EcYDM85ZU9sh_1ExnT7t3vM9X7wvgs1ZrOqf1/1ai5...