> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Filter a column or a row

> How to filter a single column or row of a table in Atoti UI on members of other hierarchies with Filter this column and Filter this row, whether the filtered column replaces the original one or comes next to it, and how to edit or remove the filter afterwards.

A [widget filter](https://docs.activeviam.com/data-visualization/atoti-ui/5.2/user-guide/create-a-dashboard/filters/about-filters.md) applies to every cell of the widget.
**Filter this column** and **Filter this row** apply a filter to a given column or row instead, or to every column or row representing a given measure.
The rest of this page refers to columns, but rows work the same way.

For instance, take a pivot table with products on rows, and the PnL and Delta measures on columns.
Filtering the Delta column on the EUR currency gives:

| Product | PnL | Delta (EUR) |
| - | - | - |
| Future | PnL of all the trades | Delta of the trades in EUR |
| Option | PnL of all the trades | Delta of the trades in EUR |
| Barrier option | PnL of all the trades | Delta of the trades in EUR |
| Equity swap | PnL of all the trades | Delta of the trades in EUR |

## How to filter a column or a row

1. Right-click a column header and select **Filter this column**.
   On a row header, select **Filter this row**.
2. In **Filtered by**, click or drag a hierarchy from the data model.
3. Select members of that hierarchy.
   Repeat steps 2 and 3 to filter on more hierarchies.
4. Optionally, rename the filtered column.
   Its default name is the caption of the header, followed by the selected members.
5. Click **Apply**.

![The context menu of the delta.SUM column header, with Filter this column
highlighted](https://mintcdn.com/activeviam/jXK2CwJRhD28R3r1/data-visualization/atoti-ui/5.2/static/img/user-guide/analyze-data/filter-a-column-or-a-row/filter-this-column-menu.png?fit=max\&auto=format\&n=jXK2CwJRhD28R3r1\&q=85\&s=a70cd10d585646b8a1797313e72a065f)

![The Filter this column popover of delta.SUM, filtered by the EUR member of
Currency, with Replace the original column
checked](https://mintcdn.com/activeviam/jXK2CwJRhD28R3r1/data-visualization/atoti-ui/5.2/static/img/user-guide/analyze-data/filter-a-column-or-a-row/filter-this-column-popover.png?fit=max\&auto=format\&n=jXK2CwJRhD28R3r1\&q=85\&s=f7887576c2aa7071a5b88460fc4a4ba7)

The filtered column takes the place of the original one.
To keep the original column as well, uncheck **Replace the original column** before clicking **Apply**.
The filtered column then comes right after the original one.

![A pivot table showing pnl.SUM, delta.SUM, and the filtered column delta.SUM
(EUR) right after
delta.SUM](https://mintcdn.com/activeviam/jXK2CwJRhD28R3r1/data-visualization/atoti-ui/5.2/static/img/user-guide/analyze-data/filter-a-column-or-a-row/filtered-column-next-to-original.png?fit=max\&auto=format\&n=jXK2CwJRhD28R3r1\&q=85\&s=0d7d2bcc6e7954e310e66eeece6d4cc9)

On a row, the checkbox reads **Replace the original row**.
And an unchecked filtered row comes right below the original one.

Selecting several members of a hierarchy aggregates their values, as a total over these members would.
The filter cannot exclude members, nor select a date range.

## Which headers can be filtered?

* A header in the last row of column headers, unless its column is a total.
  The filter applies to that column only.
* A measure in the first row of column headers.
  The filter applies to every column of that measure.

**Filter this column** is disabled on other headers.

## How to edit or remove a filter

1. Right-click the header of the filtered column, and select **Filter this column**.
   The popover shows the filter as it stands.
2. Change the name or the filters, or check or uncheck **Replace the original column**.
   Then click **Apply**.
   Alternatively, click **Remove filter**.
   The filtered column disappears, and the original column comes back if the filter replaced it.

The **Add a calculation** > **New column** popover also lists filtered columns, with an **fx** icon.
In this popover, a filtered column can only be deleted.
See [how to add a single row or column](https://docs.activeviam.com/data-visualization/atoti-ui/5.2/user-guide/analyze-data/add-a-calculation-to-a-widget.md#how-to-add-a-single-row-or-column).

## Limitations

* A filtered column replacing its original column freezes its axis: fields cannot be added or reordered on it.
  This does not apply to a filtered measure.
  To add a field, remove the filter, or uncheck **Replace the original column**.
* When the table is too large to load at once, **Filter this column** and **Filter this row** are disabled.
  So an already created filtered column can then not be edited.