Forum Discussion
How do I repeat row values in a matrix?
This seems like a simple formatting issue, but I don't see any options to make it happen.
I have a matrix with three categories in Rows, dates going across in Columns, and values going down.
The problem is, when I expand all my categories across the matrix, I just get a single instance of each category level, without repeating values. The problem is, when I export the data, I want it to look like a table, with repeated values.
In other words, right now it looks like this:
| Category 1 | Category 2 | Category 3 | 1-Jan | 2-Jan | 3-Jan |
| Food | Fruit | Apples | 2 | 1 | 2 |
| Oranges | 4 | 7 | 6 | ||
| Bananas | 9 | 5 | 2 | ||
| Vegetables | Celery | 8 | 9 | 5 | |
| Carrotts | 6 | 2 | 6 | ||
| Non-Food | Paper | Toilet Paper | 3 | 2 | 1 |
| Paper Towels | 7 | 8 | 4 |
And I want it to look like this:
| Category 1 | Category 2 | Category 3 | 1-Jan | 2-Jan | 3-Jan |
| Food | Fruit | Apples | 2 | 1 | 2 |
| Food | Fruit | Oranges | 4 | 7 | 6 |
| Food | Fruit | Bananas | 9 | 5 | 2 |
| Food | Vegetables | Celery | 8 | 9 | 5 |
| Food | Vegetables | Carrotts | 6 | 2 | 6 |
| Non-Food | Paper | Toilet Paper | 3 | 2 | 1 |
| Non-Food | Paper | Paper Towels | 7 | 8 | 4 |
Anyone know how to make this happen?
8 Replies
i had the same issue. there is awork around. in you dataset, just have an other column of INT and is unique to category3 . something like serial number for your category3 columne. use this column in rowgrouping at the highest level you will see the repeated data.
eg.
1 fruit apple
2 fruit orange
3 veg carrots
Hi
I know this is an old post now and i still can't believe this is not a standard feature of a Matrix yet... But what do you mean by Row Grouping, i can't get the concept of an idex for category three, how would that help?
Thanks
