Forum Discussion

Adil's avatar
Adil
Frequent Visitor
8 years ago

Matrix empty rows at the aggregate level

Hi Community

 

I trying to replicate an index scores and ranks in a Matrix table to be able to drill down. the index structure is translated as follows:

Level 1: Factrors

Level 2: Pillars (each factor could have 1 or many pillars)

Level 3: Dimensions (each pillar could have multiple dimensions)

Level 4: Drivers (each dimension could have some drivers)

 

I still get empty rows. for example Factor 1 score and rank are in 2 rows after (see picture below). is there anyway to fix it? 

 

Thanks

 

 

 

 

Need Help

5 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi Adil,

     

    You may could turn off the stepped layout under row headers, it will show you the Scores and Rank more obviously.

     

     

    Best Regards,

    Cherry

    • Adil's avatar
      Adil
      Frequent Visitor
      8 years ago

      Thanks for the reply

      is ther a way to make all items in one column (instead of multiple columns while turning off the stepped layout) with their respective scores and ranks?

      Also I get the sum of scores and ranks at the higher level instead of their respective values when I drill up. is there a way to fix it?

       

      Best regards

      Adil

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi Adil,

         

        I'm not very clear about your requirement.

         

        If it is convenient, could you share your desired output, so that we can help further investigate on it?

         

        Best Regards,

        Cherry