Total the rows within a column group in a matrix

  • Hello

    I have a matrix which contains forename,surname and class outside of the group and Subject and Grading type as column groups.  I have tried to add together the totals for Class and I am struggling to get this to work.  I have attached a screen shot of the export and would appreciate any help that can be offered.

    Kind regards

    Craig

     

    Attachments:
    You must be logged in to view attached files.
  • Could you post some sample data in the form of CREATE TABLE and INSERT scripts?

  • Thank you for getting back to me and I really appreciate the help.  I have added a spreadsheet with data from the dataset.

    Thanks again

    Attachments:
    You must be logged in to view attached files.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply