Forum Discussion

nh27's avatar
nh27
Helper III
4 years ago

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

  • PaulDBrown's avatar
    PaulDBrown
    Community 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