Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need to group column headers in matrix

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 
col1col2col3col4col5col6col7col8 
        
        
       

 

 

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!

Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    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

1 Reply

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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