2 Replies Latest reply on Jan 10, 2013 6:54 AM by Talia Hudspeth

    Filter an entire set of data based on one value in the set?

    Talia Hudspeth

      Good afternoon,

       

      I'm attempting to create an "honor roll" type of report - where I have a:

       

      Name

      - Course 1

      - Course 2

      - Course 3 , etc.

       

      with scores listed out. What I want to be able to do is filter out any person who has a score less than X in any one of his/her assigned courses. Thus far, I can filter out the values I don't want to see - but I haven't figured out a way to filter out the person altogether.

       

       

      Example:

      What I see now (with filter to show grades that are 80 or better, andthe strikethrough is short hand for excluded from this view!):

      Students
      CoursesGrades
      Student A


      Course 188

      Course 290

      Course 375
      Student B


      Course 199

       

       

      What I would like to see (where the strikethrough is short hand for excluded from this view!)

       

      Students
      CoursesGrades
      Student A


      Course 188

      Course 290

      Course 375
      Student B


      Course 199

       

       

      Does that make sense? I can provide more detail if needed.

       

      Thanks,

      Talia Hudspeth