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...
CaraJonesReadle's avatar
CaraJonesReadle
Frequent Visitor
8 years ago

 

What is the best way yo share the file with you seeing as the link doesn't work? The only other way I know is via e-mail.

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

Hi,

 

Upload the file to Google Drive or any other such service and share the download link.

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

      Hi,

       

      You may download my solution file from here.

       

      Hope this helps.

       

      • CaraJonesReadle's avatar
        CaraJonesReadle
        Frequent Visitor
        8 years ago

        Thanks so much Ashish this is terrific.

         

        Don't suppose you could explain how you managed to create the ranking filter, as I am sure that I will have similar situations occur on other reports I create.