Forum Discussion
Create a Matrix Table with multiple fields as rows
- 6 years ago
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:
One problem I'm running into when unpivoting is that not all fields (rows) once unpivoted are not the same data types. Some are dollar types while others are Member Numbers. So, if I want to list Total Paid Dollars but also Count the number of Members...how do you do that when unpivoting?
Is that possible?