Hi folks,
hopefully it's a silly question and easy to answer...
I have a crosstab with members from one dimension1 and members from dimension 2.
Then I have a measure that applies to both dimension. So far no problems.
Then I want to show a 2nd measure, that has connection to dimension 1, but not to dimension 2. But I want the crosstab to show the measure that applies to member of dimension 1 in alle the rows.
Like:
Measure 1 Measure 2
M1 M2 1 7
M1 M3 2 7
M1 M4 4 7
My problem is that Measure2 only comes up for the first row, the others are blank.
Is there a way to achieve this?
Thanks in advance
Florian