Top N Within Matrix visual/table with hierarchy

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

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

Best regards,

Yuliana Gu

[ash_cool10]

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