Hi @jasonzagami. While you are waiting for HubSpot’s response you might want to use the revenue projection features built into HubSpot’s CRM. Essentially, when you set up your deal stages you can assign a likelihood percentage to close to each deal stage. Each deal is given a dollar amount. Now, when deals progress through the sales funnel your reports can automatically show the projected revenue based on deal amount and likelihood percentage.
Deal weighted total report - https://knowledge.hubspot.com/articles/kcs_article/deals/what-is-the-deal-weighted-total
Setting up deal stages - Set up and manage object pipelines
Hope this is helpful.