Matrix Visual shows Two Rows?

[Anonymous]

Hi All,

         In this below snips Matrix Visual rows have three field. But It shows In One Rows like + and -.
         But I need to show the last field in different rows like the 12,16,... They are shown in the addition new row.

         It is Possible?

         Please Help me.

         Thanks in Advance. 

[Anand24 · Accepted solution]

Hi @Anonymous ,

You will need to disable the "Stepped Layout" format property. It will be enabled by default.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anonymous]

Hi @Anand24 

        Thanks for responese. 

         This is the really think i need. But It works Correctly when using two filed.

         But I need the first two rows same default format. The Third filed only shows new row in the visual.

         It is Possible?

[Anand24]

@Anonymous ,
If that's what you want, you should enable Stepped layout but move the numeric field(field having 12, 16, etc.) from Rows to Values.

From your initial screnshot, it seems you have put the numeric field into Rows which seems to be the mistake.
PFB screenshot with what you need to do with stepped layout disabled:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anonymous]

@Anand24  , 

          It's fine But the row field in matrix visual is freezed. But the value field is not freezed.

          I need the numberic field also in row field.

[Anand24]

@Anonymous ,
It is impossible to achive the format you want if you keep numeric field in rows instead of values.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Ritaf1983]

Hi @Anonymous 
You can "open" all hierarchies by drill down option and switch off the "+" if you need it :