Here is a sample of the file I'm dealing with : Companies, Training courses and length of the training courses.
A company can have a single training course and attend this courses several times
A company can have several training courses and attend them once or several times.
I need to do two things:
1. group training courses by company and calculate the average length, whatever the training courses
2. make the sum of the training courses a company has attended
Both results will be gathered in a single Summary field showing two lines :
Training length : xx months
attended courses :
Course1 : n times ; course2 : n times ; course3 : n times ; ...
thank you for your help