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:
Format | Formula | Summary | Applies To | Time Scale | |
REP05 Variance Report Staging | G2 Country, LIS: Multi-variance reporting | Month | |||
Data | Number | COLLECT() | NONE | - | Month |