Arbor Custom Report with Custom Groups

[KerryRopddy]

We print a daily sheet to manually tick students in and out every day.

In Excel a pivot groups them into categories (type of student), which we call Core, Assessment, AEP and Offsite.

 

I need student name and registration year but grouped into those categories.

I have created those custom groups, what I can't get right is how to add only the custom groups I want. I can only add all, or nothing.

Then as soon as I add the groups, the first column becomes the custom group and the student name disappears. Sorting the order does not help.

 

I need it to look like the snippet attached, (which is only showing C for Core and AEP - that snippet also shows B for bus and T for taxi... which I've not got to, to try to include in Arbor yet).

 

I've tried putting those groups into columns, and I've tried adding them to the group section, but neither works.

 

Help is appreciated. Thank you.