Forum Discussion

binbing's avatar
binbing
Icon for Helper I rankHelper I
8 years ago

A matrix displays multiple dimensions at same time, instead of drilling

Hi there,

 

could you please guide me how to  do 'A matrix displays multiple dimensions at same time, instead of drilling?'

For example, top is Region, sencond is Business Unit and third is Week.

thank you in advance!

 

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi binbing,

     

    Currently, it looks like the only way is to enable Drill down. Once we add multiple fields into column section, the matrix displays only one dimention on column header (the first field) by default. To show multiple dimentions at the same time, you have to click the drill down button.

     

    Regards,

    Yuliana Gu

    • binbing's avatar
      binbing
      Icon for Helper I rankHelper I

      Hi Yuliana,

       

      thanks for reply and confirmation.