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

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.