Forum Discussion
Formatting a matrix
If we have a Table1 like below, we can select the last 4 columns and click “Unpivot Columns” in Query Editor.
Then duplicate Table1 and remove columns of Paris and Value. Remove duplicates for the Attribute column in Table2.
Add a conditional column like below.
Close and apply Query Editor. Create relationship between Table1 and Table2 with Attribute key. Drag table columns into Matrix as below.
Best Regards,
Herbert
The problem is that my origin data is something like this:
When I Unpivot the data as you said, maintaining the dimensions and unpivoting the measures, I get:
I create the other table as you said, with a column Attribute, I do the relationship between them, but in the matrix the values og the measures don't split:
And the matrix:
Could you please describe more about “the values og the measures don't split”? What is the expected result of them?
Best Regards,
Herbert
I didn´t remember the problem, but it is solved now, thanks!