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.
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.
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?