Matrix table - no drilldown

[willielucena]

Hi!

I'd like to know if anyone knows a way to use the Matrix object with multiple columns grouped without drilldown. Example:

Group 1 Name 1 Value 1

Group 1 Name 2 Value 2

Group 2 Name 3 Value 3

Group 2 Name 3 Value 4

Group 3 Name 4 Value 5

In the table above, Group 1 should not repeat since it would be grouped.

Group 2 Name 3 as well.

I would not like to use the drilldown option. It's possible?

Thank you very much

[Anonymous]

Hi,

I think what you are looking for is under Format -> Row Headers and then make sure Stepped layout is Off. Then you can click "at the lowest level of data" at the top left corner on the matrix.

Br,

Gustav

[willielucena]

Hi, thank you for your feedback and your help. But I did not understand and could not find where the "format" option is located. Could you send a picture to help me?

[CrisYan · Accepted solution]

My Desktop is in Spanish, but the option are the same.

[willielucena]

Perfect. Thanks for your help!