Design Report

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