> ## 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.

# How to filter and sort report results

> Column filters and sort controls for loaded Risk Portal results, with Applied Filters and Applied Sorting checks to confirm the displayed selection before retaining settings in a saved report view

Applies to report grids with **Filters**, **Applied Filters**, and **Applied Sorting** controls.

Filters narrow the displayed report results.
Sorting changes their order.
These controls query existing results without changing the underlying portfolio or report definition.

## What is required before filtering or sorting?

* An accessible report with loaded results.
* A field that supports the required operation.

Available operators and conditions depend on the field and report viewer.
Text, numeric, and date fields can offer different controls.

## How to apply a column filter

1. Select **Filters** beside the results grid.
2. Open the required field's filter controls.
3. Select the required condition.
4. Enter or select the comparison value, if the condition requires one.

Wait for the results to update.
Verify that **Applied Filters** lists the intended field.
Check the returned rows against the selected condition.

<Frame caption="An NPV$ filter selects values above 1,000,000, with one applied filter. Production, October 19, 2026.">
  <img src="https://mintcdn.com/activeviam/CzXHsipTpivw-IMh/risk-and-pricing/atoti-risk-services/images/user-guide/filter-results.jpg?fit=max&auto=format&n=CzXHsipTpivw-IMh&q=85&s=150f15cae1d711a2ec287d4a801f7e31" alt="Numeric filter condition, filtered demo results, and Applied Filters indicator" width="1714" height="1101" data-path="risk-and-pricing/atoti-risk-services/images/user-guide/filter-results.jpg" />
</Frame>

A column's header menu also provides its filter controls where filtering is supported.
The header displays a filter indicator when a filter is active.

## How to remove filters

1. Select **Applied Filters** below the grid.
2. Select the listed field's filter to remove it.

Verify that the field leaves the active-filter list and the rows update.
To clear every column filter, select **Remove All Filters** from the same menu.

If **No Rows Available** appears with **Filters Applied on Columns**, review the active conditions.
An empty result does not establish that the portfolio has no positions.

## How to sort results

1. Select a sortable column header.
2. Check the direction indicator beside the header.

For an unsorted column, the first selection applies ascending order.
The next selection applies descending order; another selection clears that column's sort.
Hold **Shift** while selecting another sortable header to add a secondary sort.

Select **Applied Sorting** below the grid to inspect active sorting fields.
Select **Remove All Sorting** from that menu to clear them.
Verify that the sort indicators disappear.

## How does absolute-value sorting change the view?

The cell context menu offers **Enable Absolute Value Sorting** when that mode is disabled.
The active mode is indicated by **abs** beside sorted numeric headers.
Use **Disable Absolute Value Sorting** in the context menu to return to ordinary numeric sorting.

Check this setting when the row order differs from the expected signed numeric order.

## How can these settings be retained?

Create or update a [saved report view](./save-a-report-view) after checking the filters and sort order.
Use [Choose columns](./choose-columns) and [Group results](./group-results) for the other presentation controls.