How to use calculations from multiple queries in another query?????

[actcognosuser]

I have multiple columns in a  multiple crosstabs.

crosstab1               crosstab2           crosstab 3
region  |revenue     region|loss           region|investment

I need to use revenue ,loss and investment columns to derive another calculation.

investment - revenue+loss?

I  do not want to have crossjoins in my query?How do i go about it?revenue ,loss and investment calculations are based on some filters.Thats why they are in separate queries.i cant combine those measures in a single query.

[angela]

I would join the 3 queries by region (and any other dimensions you need like Time).  Then in the final query you can calculate an item using all 3 of the facts.  If I recall correctly you can only join 2 at a time, so you'll have to have 2 joined up, then that result with the 3rd one.