# Forecast vs closed

**URL:** <https://community.hubspot.com/t/forecast-vs-closed/109088>\
**Category:** Dashboards & Reporting\
**Tags:** enterprise\
**Created:** [June 11, 2024, 8:04am UTC](https://community.hubspot.com/t/forecast-vs-closed/109088 "2024-06-11T08:04:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SarahOps](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@SarahOps](https://community.hubspot.com/u/SarahOps)\
**Post date:** [June 11, 2024, 8:04am UTC](https://community.hubspot.com/t/forecast-vs-closed/109088/1 "2024-06-11T08:04:03Z")

</div>

Hi,

I’m looking for a way to display forecasted vs closed metric in HubSpot. E.g how much was forecasted (in $) for this quarter vs. how much closed (in $)

I’ve looked at Historical snapshot report but that doesn’t give me what I need…any ideas?

---

<div class="post-metadata">

**Author:** ![HFisher7](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hfisher7/32/101931_2.png) [@HFisher7](https://community.hubspot.com/u/HFisher7)\
**Post date:** [June 11, 2024, 8:58am UTC](https://community.hubspot.com/t/forecast-vs-closed/109088/2 "2024-06-11T08:58:44Z")

</div>

@SarahOps - Have you explored HubSpot’s forecasting tool: [https://knowledge.hubspot.com/forecast/use-the-forecast-tool?](https://knowledge.hubspot.com/forecast/use-the-forecast-tool)  
Failing that, I wonder if the [Deal pipeline waterfall report](https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool#forecasts-pipelines:~:text=Deal%20pipeline%20waterfall%3A%20revenue%20changes%20in,won%20during%20the%20close%20date%20period%20selected) will get you what you are looking for..  
**Deal pipeline waterfall:** revenue changes in the deal pipeline between two periods of time, categorized based on deal amount and close date. When factoring in a deal’s close date, the report uses the date that the deal was moved into a won/lost pipeline stage, or the _Close date_ property if the deal is in an open stage and the _Close date_ is in the future. Deals will be put into one of the following categories:

- **Created:** the total amount from the deals created during the pipeline change period.
- **Pushed:** the total amount from deals that were moved from the close date period selected to another close date period. A deal will also appear in this category if its _Close date_ is within the report’s date range and hasn’t been moved to a closed stage by the end of it.
- **Pulled:** the total amount from deals that moved from another close date period to the close date period selected.
- **Decreased:** the net decrease in the amounts from deals in the close date period selected.
- **Increased:** the net increase in the amounts from deals in the close date period selected
- **Lost:** the total amount from deals that were lost during the close date period selected.
- **Won:** the total amount from deals that were won during the close date period selected