Note: See Line item subset example for the complete list of steps.
The line item subset takes line items from three modules:
- REV03 Margin Calculation
- EMP03 Employee Expenses by Country
- OTH01 Non Employee Expenses
You can pull data from multiple modules into a target module as long as they share a common dimension. In this example, each module contains the G2 Country list.
Create the line item subset as shown in this table:
| LIS: Multi-variance reporting | |
| REV03 Margin Calculation | |
| Revenue | |
| Cost of Sales | |
| Margin | |
| Margin % | |
| EMP03 Employee Expenses by Country | |
| Headcount | |
| Salary | |
| Bonus | |
| Car costs | |
| Phone costs | |
| Medical costs | |
| Total Employee Expenses | |
| OTH01 Non Employee Expenses | |
| Shipping costs | |
| Rent | |
| Utilities | |
| Shared costs | |
| Total |