Forum Discussion
Create a Matrix Table with multiple fields as rows
Anonymous
By the looks of your source table, you need to make the rows into columns and columns into rows to get this table:
Once you have your data with this structure you can create measures and the visual you are looking for.
To tranform you source table, follow these instructions:
1) Select you "Paid" column and under the Transform tab, choose "unpivot other columns":
2) now select the "paid" column and choose pivot column with the options shown below:
Now you have the structure you need. Create the measures for each field (column) and create a matrix with your month in the column bucket and the measures in the values bucket.
Go into the formatting pane, and under values, choose "Show on Rows":
And you will get this result:
Anonymous
By the looks of your source table, you need to make the rows into columns and columns into rows to get this table:
Once you have your data with this structure you can create measures and the visual you are looking for.
To tranform you source table, follow these instructions:
1) Select you "Paid" column and under the Transform tab, choose "unpivot other columns":
2) now select the "paid" column and choose pivot column with the options shown below:
Now you have the structure you need. Create the measures for each field (column) and create a matrix with your month in the column bucket and the measures in the values bucket.
Go into the formatting pane, and under values, choose "Show on Rows":
And you will get this result: