1 Reply Latest reply on Aug 15, 2016 4:44 PM by Yuriy Fal

    Multiple ranks for hierarchical categories

    Kriti Srivastava

      I'm hoping someone can help me out;

       

      My count of usernames data is split into 2 levels, examples below:

       

      • Application IDs (e.g.141, 154,132) >
        • Function IDs(e.g. 555, 490, 340) >
          • Count Of Usernames

       

       

      For each I want to

       

      1. Rank and filter the top 10 Application IDs (by their Count of usernames)

      then

      2. Rank and filter the top 10 function Ids by count of usernames for each of the top 10 ranked/filtered Application IDs (and still show the count per function).

       

      Desperately need help please!!