> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/flex-modes/filter-data.md). # Filter data {% hint style="info" %} Filtering uses the actual stored values, not the rounded values displayed on screen. A *dimension* is a group of data, and an *entity* is a value within a dimension. For example, *Country* is a dimension, while *Australia*, *UK*, and *USA* are entities. {% endhint %} {% embed url="" %} Filter data in Flex modes {% endembed %} Filter the data in the grid to focus your analysis on the items that matter. You can apply a filter in several ways: 1. **Focus on selected rows:** Select one or more rows, then select **Focus** to keep only those items in the grid. 2. **Search for a value:** Enter text in the **Filter by keyword** box to find matching items. 3. **Filter from a cell:** Right-click a cell and select **Focus**, **Exclude**, or one of the available comparison options. 4. **Create an advanced filter:** Select the filter button to create more specific filter rules.

Ways to apply a filter to the grid

When you apply a filter, the grid updates to show the matching data and the filter displays in the filter bar above the grid. You can combine filters to progressively narrow your results. ### Choose how to filter your data Use the filtering method that best suits what you want to find: * [**Focus or exclude data**](/flex-modes/filter-data/focus-or-exclude-data.md)**:** Keep selected data in your analysis or remove data you don't want to include. * [**Search for data**](/flex-modes/filter-data/search-for-data.md)**:** Use the filter bar or a value in the grid to quickly find matching or comparative data. * [**Create advanced filters**](/flex-modes/filter-data/create-advanced-filters.md)**:** Create and combine rules when you need more control over the criteria. Focus, Exclude, searches, and filters created from the grid all create filter rules. You can view and edit these rules in the [Advanced filter](/flex-modes/filter-data/create-advanced-filters.md#open-the-advanced-filter-panel) panel. ### Work with filters Applied filters remain active as you continue your analysis. For example, you can switch dimensions or change measures while retaining the filtered dataset. 1. The filter bar above the grid shows the filters that are currently applied. 2. Hover over a filter tag to see more information. 3. Expand the filter bar to view the individual filters, then hover over a filter to see what’s included. Select a filter to view or edit its rule in the Advanced filter panel.

Filter tag in the search bar

Focused data is also indicated in the dimension list. The number beside the dimension shows how many entities are included in the focus. Select **X** to remove the focus from that dimension.
You can apply more than one filter to progressively narrow the results. For example, you might focus on a group of customers, then add another filter to show only those customers with sales above a specified value. When you apply two or more filters, the **And** indicator shows that the AND condition applies. You can change this to an OR condition in the **Advanced filter** panel.

Three filters applied to the grid with AND conditions

### Remove filters To remove a filter, click the **X** on its tag in the filter bar. To remove multiple filters at the same time, click **Clear** in the filter bar. To completely [reset the data](/flex-modes/reset-data.md), click the **Reset** button. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.phocassoftware.com/flex-modes/filter-data.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.