3 Replies Latest reply on Jun 15, 2016 2:00 AM by Kris Hallis

    Creating a set based on ID

    Kris Hallis

      Hi,

       

      I have data in a format similar to the table below.

      I have a parameter, [Selected Class], which can select the class (Maths1, Maths2 etc)

      At the moment, I am creating a set using isnull([Selected Class]) = False, which puts those pupils from the selected class into a set together.

      However, if I select 'Maths1', I don't just want Record ID 1 and 2 to be in the set, I want Record ID 1,2,5,6,9 and 10 in the set.

      Essentially I want every record of every pupil from that particular class to be included.

      Is this possible?

         

      Record IDStudent IDAssessMent NameResult
      1AAMaths15
      2BBMaths15
      3CCMaths23
      4DDMaths22
      5AAScience16
      6BBScience13
      7CCScience22
      8DDScience26
      9AAEnglish12
      10BBEnglish15
      11CCEnglish23
      12DDEnglish26

       

      Thanks very much