You can add up to three dimensions as levels in a statement. The order in which the dimensions appear in the levels box determines how the levels are applied in the statement. The addition of levels creates a ‘nested’ view of the information and allows you to view the contribution of different items within the overall performance.
The following examples illustrate how the addition of a level in a Profit and Loss statement creates subgroups in the General Ledger accounts, making the information easier to interpret.
Add one level
You add levels via the Levels box above the grid. You can either:
Then either click the Expand All button at the top of the grid or the Expand button on a specific row, such as Revenue, to view the additional levels of detail.
For example, suppose your organization operates in three countries and you want to view the contribution each country is making towards the overall revenue and expenses values.
Add multiple levels
Continuing with the example, suppose you want to get a multi-level view of the contribution each country is making towards the overall revenue value, down to the branch level.
Click and drag up the Country, Region and Branch dimensions into the levels box above the statement grid, then either click the Expand All button at the top of the grid or the Expand button on a specific row, such as Revenue, to view the additional levels of detail.
Change the order of levels
For example, suppose you add the Sub Category dimension as a level to view the totals of each expense account sub category. Then you add the Country dimension as a level, to view the expenses at the subcategory > country level (see the image on the left below). Now you want to view the expenses at the country > subcategory level (see the image on the right below).
Click the Move button on a dimension in the levels box, then drag the dimension to the left or right of the other dimension(s) in the levels box.