Forum Discussion

estefaniamc's avatar
estefaniamc
Frequent Visitor
8 years ago
Solved

Double Heading Matrix

Hi All,   I am trying to do a matrix as in the picture below, but within each month I would like to include columns that distinguish version (Outlook or Actual values). For instance I want to see a...
Need Help
Tips and Tricks
  • Abduvali's avatar
    Abduvali
    8 years ago

    Hi estefaniamc,

     

    Use Matrix table and then drop your fields as follows:

    • Step 1

     

    • Step 2

    Align Center your Headers and Values

     

     

     

     

    Hope this solves your issue.

     

     

    Regards

    Abduvali

     

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi estefaniamc,

     

    Yes. It's available to create such a Matrix.

     

    Add date hierarchy into column section, remove "Year" and "Day" values.

     

    By default, the top group level is Quarter. To drill down to Month level, click the second "Drill Down" icon.

     

    To show both Quarter and Month level as column header, you could click the third "Drill Down" icon.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi estefaniamc,

 

Yes. It's available to create such a Matrix.

 

Add date hierarchy into column section, remove "Year" and "Day" values.

 

By default, the top group level is Quarter. To drill down to Month level, click the second "Drill Down" icon.

 

To show both Quarter and Month level as column header, you could click the third "Drill Down" icon.

 

Best regards,

Yuliana Gu