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|
|Cost of Sales|
|EMP03 Employee Expenses by Country|
|Total Employee Expenses|
|OTH01 Non Employee Expenses|