I think you can calculate your revenues per team (e.g. as expression in a straight table with dimension team) like this:
=sum(aggr(sum(total<project> revenu) / sum(total<project> hrs)*sum(hrs),project,team))
Then calculate the hrs per team:
and divide first by second
Is this what you are looking for? I assumed a front end only solution, if you are not dependent on selections, you can calculate your numbers also the script.
Hope this helps,
comm68003.qvw 138.8 K