4 Replies Latest reply on Apr 22, 2018 3:43 PM by Shinichiro Murakami

    Top x Filter & Sorting

    ce.lin

      Hello,

       

      I have data on student grades by subject and school. I'm trying to get the top 3 students in each subject. I've tried to filter using the Top filter on Name, but that ignores the Course dimension. Additionally, is there a way so I can sort the values by pane? I'd trying to sort all the grades in Biology and Algebra from highest to lowest.

       

      My ideal result:

      Algebra should show Andrew M, Stephanie J, and Annie K as they have the highest scores in that subject.

      Biology should show Stephanie J, Joncel A, and Andrew M  as they have the highest scores in that subject.

       

      Thanks in Advance