Forum Discussion
Helper IIISetting up data for a matrix table
The first table is raw data, not the table visual, right? You may unpivot the table and create one addtional category column which contains categories like 'Revenue', 'Departmental Expenses' and 'Expenses' then drag the category column and the attribute column into the rows field.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support
The first table is raw data, not the table visual, right? You may unpivot the table and create one addtional category column which contains categories like 'Revenue', 'Departmental Expenses' and 'Expenses' then drag the category column and the attribute column into the rows field.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- jburklund
Thank you for the advice. I had to reorganize my data to add category and sub category columns with all of the individual variable values stored in their own row.