You can expand and collapse parent elements to explore data within the context of a report. For example, expand an expense account to see which child account is causing a variance noted at the parent level. Collapse organization levels to see the rollup at the top or parent level of the hierarchy.
Depending on whether you're expanding a row or column, child rows are added either below or to the left of the parent element. When you collapse, the child rows are removed.
Financial analysts can:
- Show the details of product revenue by its children to understand which product line is creating the variance.
- Explore the revenue by product and see which products are showing the highest gross margin over time. Next, they can filter the report by all the sales regions within the US level.
- Present financial statements to the board and drill in and show where the numbers are coming from.
You want to analyze a specific area of the model, for example, to determine your expenses by level. You also want to explode the data by both expense and level. For each child operating expense, you get a row that shows the breakdown by each child level.
Your operating expenses include:
- Taxes & Benefits
- Office Expenses
- Travel & Entertainment
- Other Expenses
Your levels include:
- Company A (100 % owned)
- Company B (40 % owned)
- Company C (80% owned)
- Proposed Acquisition Company
- Total Company (only)
When you explode, you get a row for each child operating expense type for each child level.
Do the following:
- Select a row.
- Use the Ctrl key to select and apply a parent expense account and a parent level. For example, select and apply 6000 Expenses and 7000 Allocations and Total Company.
- To the columns, apply a time element such FY 2016 .
- Select the row with the multiple parent elements applied. Right-click and select OfficeConnect > Expand.
- In the Expand dialog, select to expand both Account and Level. Use the Shift key to select both.
- Click OK.