As part of the line item subset example, create a variance report module called REP06 Variance Report. You add this module to a card on a UX page so you can see the variance per country.
Note: See Line item subset example for the complete list of steps.
In the module, put the line item subset LIS: Multi-variance report on Rows, line items on Columns, and the G2 Country list, and the Users list on Pages. The Time dimension does not apply to this module because we want to see the difference between months.
Add the following line items:
| Format | Formula | Applies To | |
| REP06 Variance Report | G2 Country, Users, LIS: Multi-variance reporting | ||
| Month 1 | Number | 'REP05 Variance Report Staging'.Data[LOOKUP: 'SYS11 Time Variance Reporting'.'Month 1'] | |
| Month 2 | Number | 'REP05 Variance Report Staging'.Data[LOOKUP: 'SYS11 Time Variance Reporting'.'Month 2'] | |
| Variance | Number | 'Month 2' - 'Month 1' | |
| % Variance | Number: Percentage | Variance / 'Month 1' |
