1. Modeling
  2. Line items
  3. Line item subsets
  4. Line item subset example
  5. Example: Create EMP03 Employee Expenses by Country module

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:

 FormatFormula
EMP03 Employee Expenses by CountryNumber  
HeadcountNumber'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country]
SalaryNumber'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Country]
BonusNumber'EMP02 Employee Expenses'.Bonus[SUM: 'SYS08 Employee Details'.Country]
Car costsNumber'EMP02 Employee Expenses'.Car Costs[SUM: 'SYS08 Employee Details'.Country]
Phone costsNumber'EMP02 Employee Expenses'.Phone Costs[SUM: 'SYS08 Employee Details'.Country]
Medical costsNumber'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Country]
 Total employee expensesNumberSalary + Bonus + Car costs + Phone costs + Medical costs