Thank you pietlinden!

I tried it and that worked for me...

Update: I was able to get the total revenue value from a sub-query after all!!

Thank you!

Have not worked with "CROSS APPLY" before. I will google that.. at first glance.. I'm looking for an equivalent for Oracle 11g

I tried calculating the total revenue by adding a sub-query to the main query but couldn't get the sub-query to properly sum when there are a series of tables that...