Create the EMP03 Employee Expenses by Country module. Use this module as part of the line item subset example.
Note: See Line item subset example for the complete list of steps.
The module contains the G2 Country list on Pages and Time on Columns. The line items are on Rows as shown in the table:
| Format | Formula | |
| EMP03 Employee Expenses by Country | Number | |
| Headcount | Number | 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country] |
| Salary | Number | 'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Country] |
| Bonus | Number | 'EMP02 Employee Expenses'.Bonus[SUM: 'SYS08 Employee Details'.Country] |
| Car costs | Number | 'EMP02 Employee Expenses'.Car Costs[SUM: 'SYS08 Employee Details'.Country] |
| Phone costs | Number | 'EMP02 Employee Expenses'.Phone Costs[SUM: 'SYS08 Employee Details'.Country] |
| Medical costs | Number | 'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Country] |
| Total employee expenses | Number | Salary + Bonus + Car costs + Phone costs + Medical costs |
