Forum Discussion
nh27
4 years agoHelper III
How to have multiple rows in Matrix Visual
Hi All,
I have 4 columns in a table that consist of data which I am trying to show in a matrix visual using month numbers as columns, however whenever I try to add in more than one value it groups it under the month, what I want is it to show as a rows grouped by month colums. I'm sure there is a simple fix but cannot for the life of me figure out how to resolve this.
Here is what is happening:
This is effectively what I would like but the columns and rows inversed i.e. PY ACT / BP / FCT / ACT as 4 rows and 12 columns for each month.
Thanks in advance.
1 Reply
- PaulDBrownCommunity Champion
Add the measures to the values bucket. In the formatting pane, search for "Show as rows" and select it. Add the month field to the column bucket