---
title: "Prefiltering a Pivot Report"
slug: "prefiltering-a-pivot-report"
updated: 2024-07-30T14:02:15Z
published: 2024-07-30T14:02:15Z
canonical: "docs.avontus.com/prefiltering-a-pivot-report"
---

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

# Prefiltering a Pivot Report

Quantify's Prefilter function enables you to build filter criteria that range from simple (with one or two criteria and logical operators) to complex (with an unlimited number of filter conditions combined with logical operators).

To prefilter a pivot report:

1. Access the appropriate pivot report.
2. Click the **Prefilter** button at the top of the pivot grid.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695391485859.png)

The *PivotGrid Prefilter* dialog appears.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695391511107.png)
3. As necessary, click the current logical operator and select a new logical operator (Or, Not And, etc.).

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695391596789.png)
4. Click the plus sign ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/8a82d7f7-cf4f-40fc-b915-916d3a3dd822.png)).
5. As necessary, click the filtering criteria and select the criteria you want to filter on from the dropdown that appears.
6. As necessary, click the condition and select the appropriate condition from the dropdown that appears.
7. As necessary, click **<enter a value>** and enter or select the value for the condition
8. Click outside the text field. The value appears to the right of the condition.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/filter(1).gif)
9. Click **Apply** to save the filter.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-5GA9ZQHX.png)
10. As necessary, use the steps above to add additional conditions or logical operators.
11. Click **Apply** and **OK** when you are done.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-30N5QMSV.png)

Once you apply the Prefilter, the prefilter panel reflects the prefilter at the bottom of the privot grid. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9996e73a-e6d7-4e50-8449-a3ba277c8cff.png) To edit the prefilter, click **Edit Prefilter** in lower the right of the dialog. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5396fcbc-fffd-463b-b99f-7ffd9ec87613.png) To disable/enable the prefilter, click the check box ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/6b44724a-3914-4a1a-bb48-90e31ff5e62e.png)) in the Prefilter panel. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3ebdde57-1c2d-4f25-b387-3248dca28320.png) To remove the prefilter, click the **Delete** button ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/db71dbc2-240e-400e-ad78-0550b2ffc8c0.png)) in the lower left. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9e9f7557-e03c-4c3d-bb42-2a1484f5d9a7.png)