Add Some Operating Expenses
Now we are going add some operating expenses to the report. To do this, we will open the Member Selector for the Account cell, and search on "operating." We will then drill into the operating expenses hierarchy, and add a function to select the children of the operating expenses before they are allocated. Finally, we will select the total operating expenses.
-
Begin by right-clicking Account, and choosing Select Members.
-
In the Member Selector, deselect Account, and then expand it. (We want to select the members of Account - not Account itself.)
-
Search on "operating".
-
The members that meet the "operating "search criteria are displayed. Highlight Operating Expenses, and click Show in Hierarchy .
-
Highlight OpEx before Alloc, click Functions , and select Children.
-
Select Operating Expenses under Gross Profit, and then click OK to close the Member Selector.
-
In the grid, expand the cell that has Children of OpEx before Allocation and OpEx. We want to separate these members into their own rows. To do this, right-click the cell, and select Separate Rows.
Children of OpEx before Allocations and OpEx are now in their own rows.
We separated the rows so that we can format them differently and add a separator between them. We will do this later on when we format the report.