Thanks to Bruce and eos, my Database file was sorted by Term and Gradelevel.
But I have noticed that the Total scores isn't affected with the selection of either the Term or Gradelevel checkboxes.. It remains as it is.. Still gives the summary of the entire scores. Same goes to Average, minimum and maximum score..
When I select the Term and Grade Level, only the records in the portal change correspondingly.
Why won't it calculate the summary or average per term and Grade Level when I select the Term and Grade checkbox?