Here’s my problem. I have a Cube with a hierarchy called Zone and the following measures: CONTRIBUTION, REVENUE, PLANNED_CONTRIBUTION, PLANNED_REVENUE.
I need to make a crosstab like this:
| Zone | Zone | | CONTRIBUTION | REVENUE | CONTRIBUTION | REVENUE | REAL | 1234 | 1234 | 1234 | 1234 | PLANNED | 1234 | 1234 | 1234 | 1234 | DIFF | 1324 | 1234 | 1324 | 1234 |
So, in the “Contribution” column, I need to show de CONTRIBUTION measure in “Real” row and PLANNED_CONTRIBUTION in “Planned” row. The same thing with REVENUE. Is it possible to do that?
I think it’s impossible, so I was thinking to make two different crosstabs like this:
| Zone | Zone | | CONTRIBUTION | REVENUE | CONTRIBUTION | REVENUE | | 1234 | 1234 | 1234 | 1234 |
But in the second one showing the “PLANNED” measures, place it under the first crosstab and then HIDE the headers, so it appears to be only one table, but now that I’ve tried to hide them I thinks it’s impossible too
Can someone help me with any of those posibble solutions or, even better, propose a new solution?