Forum Discussion

dgwilson's avatar
dgwilson
Icon for Responsive Resident rankResponsive Resident
8 years ago
Solved

Expand Matrix table horizontally

I have a Matrix with data values under a standard hierachy date column(s). (see screen capture below).

 

It's displaying 2017 and 2018 ... under which is months....

 

 

I want the Matrix to display 2017 and the months to december, then 2018 and the months to Feb (well what ever is there). I do not want users to have to work through drill down for this.

 

 

 

Can I get the Matrix to do this automatically for me?

Do I need to create my own Year/Month column to do this?

 

- David

  • Seems I've got this to work.

     

    Drill down on Columns selected and click the 3rd icon (at the lowest level of data).

    ... answered my own question!

     

     

     

1 Reply

  • dgwilson's avatar
    dgwilson
    Icon for Responsive Resident rankResponsive Resident

    Seems I've got this to work.

     

    Drill down on Columns selected and click the 3rd icon (at the lowest level of data).

    ... answered my own question!