Forum Discussion

CaraJonesReadle's avatar
CaraJonesReadle
Frequent Visitor
8 years ago
Solved

Ranking Multiple columns in a matrix

  Hello   I have a matrix that I am trying to show the top 3 Level 2 downtime areas and then show the top 3 reasons (level 3) for that area. I am using TOP N for the first column, from my research...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

You are welcome.  Share the file and tell me exactly what the problem is.

CaraJonesReadle's avatar
CaraJonesReadle
Frequent Visitor
8 years ago

Here is the link

https://drive.google.com/open?id=1Dr-XRSW58BbE5x8iyqFHvbvLXci6ljct

 

In the tab called Overall, you can see a matrix that is showing 3 levels, level 2 and event descirption are only showing the top 3 issues where as the level 3 column shows all. What I am looking for is the Top 3 level 2 events by duration that then break into the top 3 level 3 events and then the top 3 evenet descriptions.

 

 

Thanks so much for your help :)

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Someone else will help you with solving this problem.