The report information is based on two lists:
- Employees, where the employee name, location, job role and job position are stored
- Job Positions, where the FTE is stored, since FTE is an attribute of the position
The Employees list has a Job Position lookup, so it is to be added to the report first.
Other requirements include:
- The report will have the option for filtering by country
- The report grouping will be set up on location and job role levels
- The totals are a sum of values in each group, so they will be calculated as Sum