Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

I have found if I add the "Budget Millions" column into the Matrix "Row" field, it then displays the correct rows, but I dont want the "budget Millions" column in the "Frozen" section of the matrix.

 

amitchandak's avatar
amitchandak
Super User
5 years ago

StuartSmith , Matrix rows are frozen not values. but if Budget Millions is a column in row is should be frozen?

  • StuartSmith's avatar
    StuartSmith
    Power Participant
    5 years ago

    The problem is, the matrix is grouping "Budget Millions" (see below) and it doesnt give the me option to "Dont Summerise".

     

     

     

    What I want it to do is... but dont know if it is possible or i am not doing something right.

    • negi007's avatar
      negi007
      Community Champion
      5 years ago

      StuartSmith Did you try converting the data type to text that might help you. else please share your data in text format

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      5 years ago

      StuartSmith 
      Apologies if you know this already, but just in case...

      To see the values line by line you need to expand the rows. Here is an example:

      A simple matrix with several rows and one measure: notice how only the top level hierarchy is visible, and the values are grouped:

       

      If you right-click on the "Channel" field in the matrix visual, you get options:

       

      And you get this (you can format the row options under "Row Headers" in the format pane for the matrix visual)

       

      Again, apologies if you were already aware of this.