3 Replies Latest reply on Aug 1, 2013 3:32 PM by Thomas Harris

    How do you only display dimensions that meet a certain criteria based off of another dimension?

    Thomas Harris

      Greets.

      I apologize if the question was confusing; I was unsure of the best way to word it. We are an educational institution with data that shows classes taken, grades, terms, instructors, etc.. each with the Student ID as a primary key. We would like to be able to see how well students do in other classes if they have taken this or that class (or classes). 

       

      For example:

      We want to take all the students who took Class A and see how well those specific students did in class B & C.

       

      I figured it would be something along the lines of "for all the studentIDs that have this Course, then show", but I have not been able to figure out how to write out that calculation.

       

      An example of a student id would be "123456789" and a sample course name would be "BIOL1011".

       

      Any help would be greatly appreciated.


      Thanks!

       

      Thomas Harris