As part of the line item subset example, create a staging module. This module uses the COLLECT() function to pull the data from a line item subset.

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

Name the module REP05 Variance Report Staging. Put the G2 Country list and line items on Pages, the Time dimension on columns, and the subset LIS: Multi-variance reporting on Rows.

Add a line item called Data and format Data as shown:

 FormatFormulaSummaryApplies ToTime Scale
REP05 Variance Report Staging   G2 Country, LIS: Multi-variance reportingMonth
DataNumberCOLLECT()NONE-Month