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.
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.