Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Top N Within Matrix visual/table with hierarchy

Hi guys, I was wondering if there's a way to show top 10 values cascading into the next hierarchy in a matrix table? 

 

I know there is the Top N filter, which works in the first level of the hierarchy. However, when you go to next level of the hierarchy the filter doesn't get applied. 

 

Do you have any suggestions how to get around this?

 

Thanks,

CUR

Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Here is a blog describing Ranking with Hierarchy Drill-Down for your reference.

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Here is a blog describing Ranking with Hierarchy Drill-Down for your reference.

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi There,

       

      I am facing an similar issue where i am trying to find out top 5 values cascading into the next hierarchy in a matrix table.

      I have created their rank in a similar way but i am not sure how to get Top 5 values out of that Rank.

      Can you please help by telling this after creating Rank what should we do to get Top N values?

       

      Thanks,

      Ashish