---
schema_version: "1"
id: f5cef2f62e6879a0d52bf3b1669549295631897879496723f940296c2dbc74be
title: Watch Your Pipeline Change Over Time
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_track_pipeline_value.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_track_pipeline_value.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6d659a3e43d8c688de4a517c13da56b44b0a803551dc2b8a240713ed535e41bb
description: Let’s say you want to know how the total value of your pipeline today compares with its value yesterday. Create a simple report to compare the two dates.
products:
  - Cross Cloud
release: "264"
---
# Watch Your Pipeline Change Over Time

Let’s say you want to know how the total value of your pipeline today compares with its value yesterday. Create a simple report to compare the two dates.

### 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="d18991e78">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d18991e78 ">To create, edit, and delete reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d18991e78 ">
              <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>

To see Opportunities with Historical Trending, enable Historical Trend Reporting for Opportunities in Setup. For more information, seeSet Up Historical Trend Reporting in Salesforce Help.

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 **Continue**.
2. Extend the report to all opportunities and a date range of interest.
    
    ![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 To select all opportunities click **All Opportunities** when the report first opens, or click **![the filter icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_icon_filter.png) Filters** and then click **Show Me** to make your selection. To change the time range for the close date comparison, click **Close Date**.
3. Click **Outline**.
    
    The default value in the Snapshot Dates is Yesterday, and the Amount (Historical) field shows yesterday’s date.
    
    ![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 “Yesterday” is a _rolling_ date value, meaning that it points to a date that is relative to today’s date. If you run this same report tomorrow, Amount (Historical) shows today’s date.
4. To add a different start date for the snapshot comparison, click **+** and select the date. To remove a snapshot date, click **X**.
5. In the report table, click the down arrow in the headers of the Amount (Historical) and the Amount columns. Click Summarize, then select Sum.
6. In the report table, click the down arrow in the header of the Amount column. Click Show Change, then select Value.
7. Click **Run Report**.
8. In the Change column, observe the difference between the total value of the Amount (Historical) column and that of the Amount 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.

You’ve created a simple historical trending report that can help you analyze your pipeline’s behavior.

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