# Search & Filter

The search & filter features help you to focus on relevant data when there are a large number of records.

## 1. Search

The Search option helps you find characters, words, and phrases in your Inforiver report.

1.1. In the Home ribbon, click on the Search icon in the Analyze section.

<figure><img src="/files/o8FKc31LkqH1yBFscc34" alt=""><figcaption><p>Search option</p></figcaption></figure>

1.2. Type the text/value in the search box. Premium Table starts narrowing down the matches as soon as you start typing. Navigate through the results using the up and down arrows.

<figure><img src="/files/Pc3SEWx5YOgef3DmNbNG" alt=""><figcaption><p>Searching for text</p></figcaption></figure>

1.3. You can also search for specific numeric measure values.

<figure><img src="/files/nBiYSThil2mybJ616QmO" alt=""><figcaption><p>Searching for numeric values</p></figcaption></figure>

{% hint style="info" %}
Premium Table searches across pages if you are using the multiple pages option in the Design tab.
{% endhint %}

## 2. Filter

Inforiver provides nested AND/OR filtering options to filter a range of data based on the criteria you define.

### 2.1. Nested and grouped filters

a) Click on the Filter icon in the **Analyze** section of the Home ribbon.

<figure><img src="/files/tr9ivFWvIY8hXq1G5Z5R" alt=""><figcaption><p>Filter option</p></figcaption></figure>

b) Click **Add Filter**. You can filter by row dimension categories or by measures. Inforiver provides conditions depending on the filter selected. Enter a condition as shown below.

<figure><img src="/files/A6XluuQqq2RY8cCagrHx" alt=""><figcaption><p>Creating a filter condition</p></figcaption></figure>

c) The data has been filtered to show only the rows corresponding to 'Canada'.

{% hint style="info" %}
You can apply filters on manual input rows like calculated rows/static rows/template rows, etc. Learn more about [manual input rows](/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-rows.md) and [calculated rows](/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-calculated-rows.md).
{% endhint %}

<figure><img src="/files/HkFrHFhynm2lOBbHb8d1" alt=""><figcaption><p>Filter applied</p></figcaption></figure>

d) You can add multiple filters using the **Add Filter** option and can apply nested AND/OR conditions. In the below example, we have added one more condition to filter only the International region for the category Water.

<figure><img src="/files/KvRNFDPU9wpeBYyh8WOd" alt=""><figcaption><p>Adding multiple filters</p></figcaption></figure>

#### Add group

e) Inforiver also provides an option to add filter groups. Click 'Advanced'.&#x20;

<figure><img src="/files/dJpXRDi8qBPUsfSYvxQC" alt=""><figcaption><p>Advanced filter</p></figcaption></figure>

f) Click 'Add group'. We have added multiple conditions using AND/OR and using two filter groups.&#x20;

<figure><img src="/files/y3SA0VVi64BeVOrsMZsI" alt=""><figcaption><p>Grouping filters</p></figcaption></figure>

g) You can delete the individual filters by clicking on the <img src="/files/rBxo45mh9zYFCIfj80NF" alt="" data-size="line"> icon available next to the condition.

h) If you want to temporarily turn off all the filters, select the 'No Filter' option from the dropdown.

<figure><img src="/files/jmPChM1itmm2IPnpM6GY" alt=""><figcaption><p>Removing filters</p></figcaption></figure>

i) The 'Persist filters' option ensures the filters are retained when switching between pages in the report.&#x20;

### 2.2. Column-level filter

Premium Table provides nested AND/OR column-based filtering options to filter a range of data based on the criteria you define.&#x20;

a) When you hover over any column, a hamburger menu appears as highlighted. Click on the hamburger menu (column gripper) and then click on the<img src="/files/9ZMWMrchXJNjPbP91q3k" alt="" data-size="line"> icon.

<figure><img src="/files/4P6ekd1ZCqrVJbvB1ggS" alt=""><figcaption><p>Column level filter</p></figcaption></figure>

b) Choose the filter condition from the drop-down and enter the filter value. Let us consider an example to apply a column filter on the Plan measure to display the rows with a Plan < 20k. The data gets filtered to show only the values corresponding to the filter condition.

<figure><img src="/files/gdIB8s6DSIvoEE58f1Ev" alt=""><figcaption><p>Creating column level filters</p></figcaption></figure>

d) You can add nested AND/OR filters by clicking the **Add rule** option. In the example, we have added one more condition.

<figure><img src="/files/b2403zNuI5xN7kLSZvep" alt=""><figcaption><p>Adding multiple filter conditions for columns</p></figcaption></figure>

{% hint style="info" %}
You can click 'Clear filter' to clear all the column filters applied.
{% endhint %}

In the next section, we'll look at the [KPI Explorer](/premium-table/working-with-premium-table/3.-basic-interactions/explore-and-filter-data/explorer.md).&#x20;


---

# Agent Instructions: 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:

```
GET https://docs.inforiver.com/premium-table/working-with-premium-table/3.-basic-interactions/explore-and-filter-data/search-and-filter.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.