Forum Discussion
Have row items repeat which represent grouping in a Matrix table
Hi , I am trying to build a table that looks like the below table. My dataset is unpivoted having the months in one column. I would use the Matrix visual to get the months as individual columns however the rows gets nested in each other forming hierarchy and I have to keep expanding the rows to see the other columns. How can I do this without using the regular table visual or pivoting my dataset
Dataset looks like this form:
| StudentID | StudentName | Teacher | Subject | Month | Grade |
| 1A2 | John | Joe | Math | Jan | 90% |
| 1A2 | John | Joe | Math | Feb | 81% |
| 1A2 | John | Joe | Math | Mar | 91% |
| 1A2 | John | Jessica | English | Jan | 95% |
| 1A2 | John | Jessica | English | Feb | 95% |
| 1A2 | John | Jessica | English | Mar | 89% |
| 2B2 | Peter | Sparkle | Science | Jan | 68% |
| 2B2 | Peter | Sparkle | Science | Feb | 72% |
| 2B2 | Peter | Sparkle | Science | Mar | 78% |
| 5C2 | Gary | Coby | Art | Jan | 100% |
| 5C2 | Gary | Coby | Art | Feb | 100% |
| 5C2 | Gary | Coby | Art | Mar | 96% |
| 5C2 | Gary | Baugh | History | Jan | 59% |
| 5C2 | Gary | Baugh | History | Feb | 76% |
| 5C2 | Gary | Baugh | History | Mar | 74% |
| 5C2 | Gary | Joe | Math | Jan | 99% |
| 5C2 | Gary | Joe | Math | Feb | 96% |
| 5C2 | Gary | Joe | Math | Mar | 91% |
| 10Y6 | Kyle | Errol | Geography | Jan | 88% |
| 10Y6 | Kyle | Errol | Geography | Feb | 90% |
| 10Y6 | Kyle | Errol | Geography | Mar | 97% |
visualization I want to achieve
| StudentID | StudentName | Subject | Teacher | Jan | Feb | Mar |
| 1A2 | John | Math | Joe | 90% | 81% | 91% |
| 1A2 | John | English | Jessica | 95% | 95% | 89% |
| 2B2 | Peter | Science | Sparkle | 68% | 72% | 78% |
| 5C2 | Gary | Art | Coby | 100% | 100% | 96% |
| 5C2 | Gary | History | Baugh | 59% | 76% | 74% |
| 5C2 | Gary | Math | Joe | 99% | 96% | 91% |
| 10Y6 | Kyle | Geography | Errol | 88% | 90% | 97% |
Hey Sagejah9 ,
transforming a matrix visual that looks like this:
with its nested row headers
into something that looks like this:
Mark the matrix visual and then change the formatting of the matrix visual:
- turn off the "Stepped layout" and the "+/- icons"options
- turn off the "Row subtotals"
Hopefully, this is what you are looking for.
Regards,
Tom
- turn off the "Stepped layout" and the "+/- icons"options
1 Reply
Hey Sagejah9 ,
transforming a matrix visual that looks like this:
with its nested row headers
into something that looks like this:
Mark the matrix visual and then change the formatting of the matrix visual:
- turn off the "Stepped layout" and the "+/- icons"options
- turn off the "Row subtotals"
Hopefully, this is what you are looking for.
Regards,
Tom
- turn off the "Stepped layout" and the "+/- icons"options