To create a list that shows the count of individual classes by grade level:
  1. Lists
  2. View All 
  3. Click Add and Select Create Advanced List
  4. Give your List a name
  5. Select a Category if Desired
  6. Click the Select Objects Tab
  7. Under Constituent Information Object, Select User Base and User Role
  8. Under Academic Group, Select Course Enrollment, Course Group, Course Base, Course Detail, Course Department, Academic Department, and Course Term
  9. Under School, Select School Year
  10. Under Academic Group, Select Course Faculty
  11. From the Drop down menu that appears select the option for Course Group.Group ID = Course Faculty.Group ID and Click Select
  12. Under Constituent Information Object, Select User Base
  13. From the Drop down menu that appears select the option for Course Faculty.Faculty User ID = User Base.User ID and Click Select
  14.  Also Select User Register and from the Drop down menu that appears select the option for User Base.User ID = User Register.Student User ID
  15. Click Select
  16. Under School, Select School Year
  17. Under Platform, Select Grade Level
  18. Click the Display Fields Tab next to the Select Objects tab
  19. Check Enable Grouping Options
  20. Click the Select Fields... Link under the  No Display Fields Selected.
  21. From the box that appears expand out the different sections and check the following boxes.
  22. Under User Base Check the User ID box
  23. Under Course Base Check the Course Title and School Level boxes
  24. Under Course Detail Check the Course Type box
  25. Under Academic Department Check the Department box
  26. Under Course Term Check the School Year box
  27. Under Grade Level Check the Grade Level Description box
  28. Click Select on the top right on the Select Display Fields Box
  29. Rename the User ID Field as Student Count and under Grouping, select Count
  30. If desired rename Grade Level Description as Grade Level
  31. Change the column order to best suit your desired order
  32. Select the Filters Tab next to the Display Fields Tab
  33. Under Global Filters from the Drop down scroll down to and select User Role. Role and select the condition of any of Student
  34. Click the + to give yourself another row and from the Drop down select Course Enrollment. Enrolled with the condition is not null
  35. Click the + to give yourself another row and from the Drop down select School Year.Current Year with the condition of is True
  36. Click the + to give yourself another row and from the Drop down select School Year [1].Current Year with the condition of is True
  37. Click the + to give yourself a final row and from the Drop down select Course Term.Term Description with the condition is (Name of Term such as Fall)