# Filter data

{% hint style="success" %}
See these related pages:

* [Dimensions](https://app.gitbook.com/s/7pj8v25BOyqZTdG5mdD1/getting-started/dimensions): General information about dimensions, a core concept in Phocas.
* [Overview of financial statements and dimensions](https://docs.phocassoftware.com/financial-statements/getting-started/overview-of-the-link-between-financial-statements-and-dimensions): Information about the link between dimensions and Financial Statements.
  {% endhint %}

Instead of only looking at the high-level totals in your financial statements, you can filter the data. For example, you might want to view figures by department, region, or product line.

You can filter your financial data directly in the Financial Statements module, or start there and move into the Analytics module.

{% embed url="<https://phocassoftware.wistia.com/medias/02u3ckaz4z>" %}
Filter your financial data
{% endembed %}

## Filter directly in Financial Statements

The fastest way is to drag a dimension into the **Filters** drop zone, then select the items you want to filter by using the drop-down menu. The selected filters appear above the grid so you can easily see which criteria are applied.

<div align="left"><figure><img src="https://3180484653-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKhoFIsurMPEjkuBz9YkN%2Fuploads%2Fc9ADFsGvYM60vMUTxC3y%2FFS%20filtering_no%20lines.gif?alt=media&#x26;token=67bf5a53-9d16-40c3-bcab-3e7701d06238" alt=""><figcaption><p>Filter your data by dragging a dimension into the Filters drop zone</p></figcaption></figure></div>

## Filter using the Analytics module

In Financial Statements, click the dimension you want to use as a filter, such as Country, Branch, Department, and so on. You move into the Analytics module, where you'll notice some of the menu items change and the **Summary** button turns grey. The Analytics grid displays a summary of performance for each entity in the selected dimension.

<div align="left"><figure><img src="https://content.gitbook.com/content/KhoFIsurMPEjkuBz9YkN/blobs/rQsqCNEfE5ndjgT2u6b7/2995421634.png" alt=""><figcaption></figcaption></figure></div>

From here, you have two options:

* Use the range of Analytics tools to drill deeper into your data, all the way down to the transaction level. See the [Analytics pages](https://app.gitbook.com/s/itAvDF3MljQXV0rjHRP7/) for detailed information.
* Select one or more entities in the grid, then click the **Summary** button to return to the Financial Statements module and view the filtered statement. The filter you apply displays above the grid, and the number of selected entities displays on the corresponding dimension button.

<div align="left"><figure><img src="https://content.gitbook.com/content/KhoFIsurMPEjkuBz9YkN/blobs/Hw6Pw0QRXMlWeY9zKuUp/2995029096.png" alt=""><figcaption></figcaption></figure></div>

Expand the sections below for more examples.

<details>

<summary>Example 1: Filter a financial statement to view the performance of one branch</summary>

In the financial statement, click the **Branch** dimension, then in the Analytics grid, select the branch (B008) and click the **Summary** button.

The statement grid now displays the Profit and Loss for branch B008.

<div align="left"><img src="https://content.gitbook.com/content/KhoFIsurMPEjkuBz9YkN/blobs/vgTLOzAWwjASn0zAXuA8/2846818380.png" alt=""></div>

</details>

<details>

<summary>Example 2: Filter a financial statement to view the performance of multiple branches</summary>

In the financial statement, click the **Branch** dimension, then in the Analytics grid, select the branches (B002, B003 and B004) and click the **Summary** button.

The statement grid now displays the combined Profit and Loss statement for the selected branches. The net profit value is the sum of the net profits of those branches.

<div align="left"><img src="https://content.gitbook.com/content/KhoFIsurMPEjkuBz9YkN/blobs/8zHqyv8Q6CSEBjAdNiXk/2847178830.png" alt=""></div>

</details>

<details>

<summary>Example 3: Filter a financial statement to view the performance of multiple cost centres in a branch</summary>

Suppose you have filtered the Profit and Loss statement by Country (dimension) > Australia (entity). Now you want to take your analysis a step further and see how two specific cost centres in Australia are performing.

In the filtered financial statement, click the **Cost Centre** dimension.

<div align="left"><img src="https://content.gitbook.com/content/KhoFIsurMPEjkuBz9YkN/blobs/PrvoDM8TUbiTqPapH6I0/2995617880.png" alt=""></div>

In the Analytics grid, select the cost centres (C001 and C004) and click the **Summary** button.

The statement grid now displays the combined Profit and Loss statement for the selected cost centres in Australia. The net profit value is the sum of the net profits of those cost centres.

<div align="left"><img src="https://content.gitbook.com/content/KhoFIsurMPEjkuBz9YkN/blobs/rwJKzBYAdjQ4cuhTYHyQ/2995617886.png" alt=""></div>

</details>

## Remove a filter <a href="#filterthefinancialinformation-removeafilter" id="filterthefinancialinformation-removeafilter"></a>

To remove a filter and return to the high-level summary financial information, click the **X** in the filter chip or on the dimension button.

To completely reset the data, click the **Reset** button.
