Page Comparison

You can filter the summary financial information to analyze on the performance of specific entities in a dimension. You can display the filtered information in two ways:

• Basic - The filtered information displays in the statement grid. The grid looks the same as usual but the values now relate to the specified entity or group of entities. This is useful when you want to focus on the performance of one entity or a particular group of entities

• Matrix - The statement grid converts into a matrix format. The original summary combined financial information displays in the Total column and beside that are additional columns for the filtered information (entity or group of entities). The values in the total rows, such as gross profit, are at the summary and entity level respectively. This method is useful when you want to compare the performance of entities side-by-side, against the overall their combined performance.

For example, suppose you want to analyze your organization’s performance at the branch level. There are a number of ways to do this, as outlined in the steps and examples below.

1. Click the Branch dimension. The statement grid converts into a data grid, where you can see a summary performance of each branch.

2. In the data grid, select the branch(es) you want to focus on by clicking the number in the beginning of its row, or click the Select All button to select all the branchesthe applicable row(s).

3. Select one of these display methods:

   • Basic: Click the Summary button. The data grid converts back into the financial statements grid, where you can see the Profit and Loss statement for the selected branch (es)or the combined Profit and Loss statement, if you selected more than one branch.

   • Matrix: Click the Matrix button, then click the Summary button. The data grid converts back into the financial statements grid, where you can see the Profit and Loss statement for the branch(es) to the right of the summary combined Profit and Loss statement.

Expand
title Example 1: Filter a financial statement to view the performance of one branch (basic view).

Expand
title Example 2: Filter a financial statement to view the performance of one branch and compare it to the overall organization performance (matrix view).
Image Removed
Expand
title Example 3: Filter a financial statement to view the performance of a selection of branches (basic view).
Info In the statement grid you can see the combined Profit and Loss statement for the selected branches. The net profit value is the sum of the net profits of those branches.

Expand
title Example 43: Filter a financial statement to view and compare the performance of a selection of branches (matrix view).
Info
.
Tip If you select multiple entities to use with the matrix tool, you might be presented with a lot of data in the financial statements grid. To reduce the amount of data and get a clearer view of the key information, remove some columns.

Expand
title Example 5: View and compare the performance of all branches in a matrix format (no filters)
Whereas the above examples involve filtering a dimension, you can use the matrix tool without filtering a dimension, to view the information for all the entities in the dimension alongside the summary information. Continuing with the above examples, suppose you want to compare the performance of all branches side-by-side, against the overall organization performance (summary Profit and Loss statement). Image Removed Tip If you select multiple entities to use with the matrix tool, you might be presented with a lot of data in the financial statements grid. To reduce the amount of data and get a clearer view of the key information, remove some columns.