How get mupltple recordcounts from a column?
I have multiple courses in a column and another column for the company putting on the courses. I would like to be able to count all the courses registered per company and group the results by companies with the number of courses displayed.
Grouping in output is easy to do. However using count() sum() or recordcount will not give me a breakdown of how many classes have been registered for each company.
Ie:
Company name
Class 1…Registered(1)
Class2 …Registered(4)
Company Name
Class3…Registered (0)
Class4…Registered (1)
Any help would be appreciated.
