Forum Discussion
CaraJonesReadle
8 years agoFrequent Visitor
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...
- 8 years ago
Hi Ashish
Hopefully this works
https://drive.google.com/file/d/1U0DWUxqqb8Spd3OhaYwwyae-TqTf-4Gq/view?usp=sharing
Thanks
Cara
CaraJonesReadle
8 years agoFrequent Visitor
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
Super User
8 years agoHi,
Someone else will help you with solving this problem.