Creating a matrix group by issue

[alvarotoral]

Hi,

I'm having an issue creating a matrix visualization. I have list that needs to be group by four different levels (Site, Block, Location and Area), after those four levels have been expanded it needs to show all the details for the rows under it, but when I add a detail column to the Rows section in the matrix, it adds it as another level. The details are plain text and what I'm trying to replicate is how a grouped by SharePoint List works.

Here's an image of my data:

As you can see I have the fist four columns as the levels I would like to group by my data. Then,, the last two columns Tipo_Visita and Nombre_Completo would be the detail, so when all the levels are expanded, it should show those five rows. And what Im getting is this:

Any help would be appreciated, thanks in advance.

[alvarotoral]

Hi @mhossain ,

Thanks for the response, but I've already tried this option and it's returning the desired result. I'm looking to replicate something like this:

[mhossain]

@alvarotoral 

Thanks, got it.

I think it's not doable at the moment the way you require matrix table to be in, lets see if anyone comes up with suggestions.

[mhossain]

@alvarotoral 

Under the 'Row Heading' format setting, try to turn on the Stepped layout option, hope this helps. Or you are looking for something else?