Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Append in Matrix (or not Grouping rows)

Hello everyone!

I have built a fact table A that its rows are combination of every person and question made to that person and its answer (Yes/no). It looks like that:

And I have one dimension table with all questions listed and 2 columns that gives 2 classifications of that question. Something like that:

 

So, at my report, I want to build a matrix that shows something like the following:

 

 

But I can't seem to achieve it, the only result that i get is building two matrix, one for type_1 rows and other for type_2:

 

When i try to append the rows by inserting both fields in the row section, i just get the combination of them both.

Is that a way to achieve it? 

 

Thanks in advance,

Gabriel Monteiro