Need to group column headers in matrix

[Anonymous]

Hi All,

So I need to have a table like structure which has around 20-25 columns with the group headings like this:

Group1			Group2			Group3
col1	col2	col3	col4	col5	col6	col7	col8

Group1, Group2, Group3 are just static text headings but I am not sure how to add column headings like this.

and the problem is that since I have too many columns to show, I can't add text boxs above my matrix visual as it won't be in sync with the horizontal scroll bar.

Any suggestions how to achieve this?

Thanks in advance!

[PC2790 · Accepted solution]

Hi @Anonymous ,

I addressed the similar requirement by having a separate table with Column Names as Category and Sub Category. Something like this:

You can have a third column like date which I used to create the relationships between other tables.

The matrix looks something like:

Not sure if this will be applicable in your case but you can always take away something from this implementation.

Thanks