---
schema_version: "1"
id: 4e121c422dc16788bd4418e9535f327a68e69e257b8b8deea0293f7ac812dec8
title: Find Deals that Have Been Pushed Out
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_track_pipeline_mix.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_track_pipeline_mix.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5a09d06eea34fc1119e860c798effbc6122ca830c8c3f4aceaf3bcd35a32c5f2
description: To focus on deals that are taking more time to close than expected, create a historical trending report that finds deals in your pipeline that have had their close dates moved to a later date.
products:
  - Cross Cloud
release: "264"
---
# Find Deals that Have Been Pushed Out

To focus on deals that are taking more time to close than expected, create a historical trending report that finds deals in your pipeline that have had their close dates moved to a later date.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d25585e78">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d25585e78 ">To create, edit, and delete reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d25585e78 ">
              <dl>

                <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">Create and Customize Reports <p>AND</p>
                  <p style="margin-bottom:0;">Report Builder</p>
                </dd>

              </dl>
            </td>

          </tr>
        </tbody>
      </table>

1. Create an opportunity history report.
    1. On the Analytics tab, select **Create** | **Report**, or on the Reports tab, click **New Report**.
    2. Select **Select Report Type** | **Opportunities** | **Opportunities with Historical Trending**.
        
        To see Opportunities with Historical Trending, enable **Historical Trend Reporting for Opportunities** in Setup. For more information, see Set Up Historical Trend Reporting in Salesforce Help.
    3. Click **Create**.
2. For Show, select **All Opportunities**.
3. Filter for close dates that are later now than they were in the past.
    1. Click **Add** and select Historical Field Filter.
    2. Set Close Date (Historical) to Feb. 1, 2013.
        
        ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_tip.png)
        
        Tip Use the calendar under **Fixed Days** to select the date.
    3. Click **OK**.
4. Click the down arrow in the header of the Close Date column and select Show Changes.
5. Click **Run Report**.
6. For each deal in the report, compare the date in the Close Date — Historical column with the date in the Close Date — Today column.
    
    ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_tip.png)
    
    Tip You can see changes at a glance by looking for values that are colored green or red.

#### See Also

- [Opportunities with Historical Trending Report](https://help.salesforce.com/s/articleView?id=analytics.reports_opps_trending.htm&release=264.0.0&type=5 "The Opportunities with Historical Trending report is a custom report type designed to help you analyze historical trends in your sales pipeline.")