Historical trending analysis can help you prioritize by quickly identifying deals that
are at risk. For example, target the deals in your pipeline that have decreased in value since
yesterday. Use a historical trending report that gives you the deals whose value yesterday was
greater than their value today.
Required Editions
Available in: Lightning Experience
Available in: Enterprise, Performance, Unlimited, and
Developer Editions
Available in: Enhanced Folder Sharing
User Permissions Needed
To create, edit, and delete reports:
Enhanced Folder Sharing
Create and Customize Reports
AND
Report Builder
Create an opportunity history report.
On the Analytics tab, select Create | Report, or on the Reports tab, click New Report.
Select Select Report Type | Opportunities | Opportunities with Historical Trending.
If you don’t see the Opportunities with Historical Trending report type, enable
Historical Trend Reporting for Opportunities in Setup.
Click Create or Continue.
Select the option to show All Opportunities.
Filter out any deal that wasn’t worth more yesterday than today.
(Lightning Experience) Open the Filters pane. Click Add Filter and
select Amount (Historical). For the date, select
Yesterday. For the operator, select greater
than. To compare yesterday’s Amount value with today, click , and select Field.
(Salesforce Classic) Click Add and select Historical
Field Filter. Select Amount (Historical). For the date,
select Yesterday. For the operator, select greater
than. To compare yesterday’s Amount value with today, click , and select Field.
Run the report.
You’ve created a simple report that flags deals that have shrunk since yesterday. All
the results in the Amount — Today column are shown in red, to
indicate decreases in value.
Tip To change the color-coding for amount changes,
click the down arrow above the Change column and click Reverse
Colors.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
