Forum Discussion

CaraJonesReadle's avatar
CaraJonesReadle
Frequent Visitor
8 years ago

HI Ashish

 

Your solution has been working brilliantly, thank-you again.

 

I am wondering though, I now want to have 3 columns each showing the top 3 issues based on duration. I have copied the rank x formula for the 3rd column that I want to add, however now column 2 losses its ranking when i apply this. How can I rectify this issue?

 

Thanks

Cara

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.