"union" multiple rows to one

[Anonymous]

Hi all,

sorry for the strange title - but i dont know how to name my question better.

I have the two 2 Dimensions

[FREEZE]
[TIME]

and one Fact 

[FACT]

used in a Matrix.

[TIME].[MONTH] as columns, [FREEZE].[NAME] as rows and [FACT].[MEASURE] as value.

As you can see in the followling screenshot a value only exists when [TIME].[MONTH] and [FREEZE].[NAME] are equal.

That will always be the case.

I now want to achive a display of the matrix like that:

So i think i have to remove [FREEZE].[NAME] from the rows and put it somehow in my calculated measure, right?

Kind regards

Jack

[Anonymous]

@lbendlin i get 1 row but with "wrong" data because i've lost the FREEZE[NAME] context in my measure now

[lbendlin]

yes.  What happens if you do only the first part (remove FREEZE[NAME] from rows)?