Hi Austen

It sounds as though you are talking about the ability to create grouping in the report builder if the group is not already defined in the report source.

Currently grouping is possible in the report source eg Course completion by organisation but you can't change the grouping using the report builder interface.

The closest report source in Totara is probably Record of Learning Courses that has user and course grade info in it.

Excel does grouping pretty well using pivot tables. You could group with multiple levels eg user, category, enrolment date, grade etc . Excel is capable of analysing hundreds of thousands of rows rapidly and also create charts so your large spreadsheet shouldn't pose too many problems.

More report data sources are being created, it sounds like this one might be a good candidate.

Craig