If you are unable to create a new account, please email support@bspsoftware.com

 

Show a measure in crosstab that does not belong to dimension shown on rows

Started by florian, 03 Jul 2015 02:21:02 AM

Previous topic - Next topic

florian

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