Matrix headings subdivided

[saranee]

Hi all,

Appreciate a little help on this :

we need a matrix structure like this with two columns subdivided into sub headers,will this structure be possible?

[TomMartens]

Hey,

this will be possible using the Matrix visual

Hopefully this is what you are looking for

Regards

Tom

[anoop2895]

Instead of clicking the expand button there, is it possible to get the subdvided columns as the default visual of the matrix ?

[saranee]

Thanks for your reply Tom.But what in uderstand from your matrix is that values of a column are used as columns in the matrix.

But the columns shown in my matrix are distinct columns with no relation to each other and need to be shown side  by side and then further classified into 3 more new columns 

Thanks,

saranee

[v-chuncz-msft]

@saranee,

You may first create a calculated table.