I am trying to produce a matrix for school grades. Currently, I have a matrix that lists the grades by subject, then teacher, then the name of each grade (one for attainment, one for effort). I have another Query that pulls through the students target grades and I would like them listed as well. When I insert the target values into the Columns field, it puts a target column in front of every other column.
So before it looked like this (obviously, the header cells are merged in the matrix):
| Art | | | | English | | | |
| Teacher1 | | Teacher2 | | Teacher3 | | Teacher4 | |
| Grade | Effort | Grade | Effort | Grade | Effort | Grade | Effort |
| A | 1 | A | 1 | A | 1 | A | 1 |
| B | 2 | B | 2 | B | 2 | B | 2 |
| C | 3 | C | 3 | C | 3 | C | 3 |
Then when I added the new values it looked like this:
| Art | | | | | | | | English | | | | | | | |
| Teacher1 | | | | Teacher2 | | | | Teacher3 | | | | Teacher4 | | | |
| Target | Grade | Target | Effort | Target | Grade | Target | Effort | Target | Grade | Target | Effort | Target | Grade | Target | Effort |
| A | A | A | 1 | A | A | A | 1 | A | A | A | 1 | A | A | A | 1 |
| A | B | A | 2 | A | B | A | 2 | A | B | A | 2 | A | B | A | 2 |
| A | C | A | 3 | A | C | A | 3 | A | C | A | 3 | A | C | A | 3 |
And what I want it to look like is this:
| Art | | | | | | English | | | | | |
| Teacher1 | | | Teacher2 | | | Teacher3 | | | Teacher4 | | |
| Target | Grade | Effort | Target | Grade | Effort | Target | Grade | Effort | Target | Grade | Effort |
| A | A | 1 | A | A | 1 | A | A | 1 | A | A | 1 |
| A | B | 2 | A | B | 2 | A | B | 2 | A | B | 2 |
| A | C | 3 | A | C | 3 | A | C | 3 | A | C | 3 |
Does anyone know if this is possible? I would even settle for having one target column at the beginning of the subject if that's easier?
Thanks
