# How to Filter Out Deleted Deals in Hubspot

---

***An API limitation in Hubspot makes it impossible to remove deleted deals from your data set. Follow the instructions in this article to learn how to filter out deals that you no longer want in your reports.***

---

## Data Studio

Select a chart that contains the field **Deal ID**. If a chart does not contain the field, you can add it by selecting the chart and dragging **Deal ID** to Dimensions.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-1.png)

Click **Add a Filter**.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-2.png)

Click **Create a Filter**.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-3.png)

Name the filter something you can remember, like "deleted deals." Choose **Exclude** \> **Deal ID** \> **Equal to (=)** \> (Deal ID number).

If you need to exclude more than one Deal ID number, click **OR**.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-4.png)

Each Deal ID number must be added separately. Click **Save** when you have added all of your deleted Deal ID numbers.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-5.png)

The filter must be applied to each chart that includes the **Deal ID** field.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-6.png)

## Google Sheets or Excel

Select **Filter** on the Power My Analytics sidebar and complete the form as follows:

- **Method:** Exclude data.
- **And/Or:** Or.
- **Select field:** Deal ID.
- **Comparison Operator:** Equal to.
- **Comparison value:** Enter the Deal ID number you wish to exclude.

Then click **Save**.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-7.png)

Each Deal ID number must be added separately. Click **Set Filter** when you have added all of your deleted Deal ID numbers.

![](https://knowledge.powermyanalytics.com/application/sources/images/how-to-filter-out-deleted-deals-in-hubspot-8.png)
