COLLECT

The COLLECT function can be used to collect values from a line item subset. In this example, the two source modules for the line item subset are named P&L and Fixed assets. The aggregated total for FY22 from the Time dimension displays as the single column in both modules, and line items on rows.

P&L module:

Revenue module:

The line items selected for the line item subset display as below within Line item subsets . The line item subset is named Receipts and Payments.

	Receipts and Payments
P&L
Sales last year
% increase
Sales	true
Margin %
Cost of Sales	true
Gross Margin	true
Headcount
Cost per employee
Staff Costs	true
Rent & Rates	true
Utilities	true
Marketing	true
IT costs	true
Total Overheads	true
Operating Profit	true
Fixed assets
Assets Sold	true
Buildings	true
Fixtures	true
Software	true
Patents	true
Assets Purchased	true

The above line item subset is used for the rows dimension in a Receipts and Payments module. FY22 from the Time dimension is on columns, and a single line item is on the pages dimension. The line item contains this formula: COLLECT(). This collects the values from the P&L and Fixed Assets source modules:

The Variance report staging module step of the Line item subset example contains an example of how you can use the COLLECT function.