Forum Discussion
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
Anonymous , You can unpivot the table 2 (Type_1, Type_2) , that will create a many to many case, but it should work
2 Replies
- amitchandak
Super User
Anonymous , You can unpivot the table 2 (Type_1, Type_2) , that will create a many to many case, but it should work
- AnonymousNot applicable
Thanks amitchandak , that's what i was looking for, but i was afraid of using Many to Many relationship. Just for curiosity, Is that another way to solve this?