1. Modeling
  2. Line items
  3. Line item subsets
  4. Line item subset example
  5. Example: Create line item subset LIS: Multi-variance reporting

As part of the line item subset example, create a line item subset called LIS: Multi-variance reporting. 

Note: See Line item subset example for the complete list of steps.

The line item subset takes line items from three modules:

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