Forecast by Month and Opportunity Report Template

  • 17 March 2023
  • 2 replies

Userlevel 1
Badge +1

Hi, is there a template for report like this, or a tutorial that would help me build it? Thanks


2 replies

Userlevel 2
Badge +2

Hi @triches , thank you for reaching out to the Copper Community! This insight can be generated in Copper Reports. I’ve included a screenshot of the setup below. 

In order to build this insight, please ensure the following fields are all filled in for your opportunities:

  1. Value
  2. Closed Date (Input expected close date for forecasting current opportunities)
  3. Opportunity Name

Insight Setup:

Metrics: Opp Value

Rows: Opp Name

Column: Date → Date as: Opp Closed At → group by: Month


Here are additional reporting resources to help you get started in Reports:

Reports in Copper: an introduction

Reports: Creating a custom insight

Userlevel 1
Badge +1

Thanks @Chris from Copper really helpful. Is it possible to get the Total for the month at the bottom of each column as well? 


I’ll check out the additional tutorials.