Forum Discussion

Nash2Bos's avatar
Nash2Bos
Helper I
1 year ago
Solved

Formating a visual table

Hello all i was wonding if i can get a matrix table to look something like this? Haven't been able to get it. 

Q1                       | Q2                      |            Q3
JAN| FEB| MAR    | APR| MAY |JUN  | JULY | AUG| SEP 

 

I want to keep the dates on the top but have a second level for month and dates. 

 

Thank you in advance

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi

    first add date hierarchy in columns field in visual pane. Then remove Day & Year from there

    Click on below button on matrix visual

    Thanks & Regards

    Pravin Angane

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi 

     

    You can add Horizon & Vertical Gridlines for Matrix Visual.

     

    Thanks & Regards

    Pravin Angane

    • Nash2Bos's avatar
      Nash2Bos
      Helper I

      but how do i get the months under the quarters. it only allows one

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi

    first add date hierarchy in columns field in visual pane. Then remove Day & Year from there

    Click on below button on matrix visual

    Thanks & Regards

    Pravin Angane