+ Start a Discussion

Custom Open Opportunity History Report - is this possible?



I am trying to create a statement of changes for Opened opportunities but not sure how to do it.  The report is a simple table in excel with the following fields:


                                                                     January         February         March ....


   Opening Balance ($ Open Opportunities)    1,000,000        844,000

 + New Opportunities created                           +20,000          etc

 -  Wins                                                            -50,000           etc

 - Losses                                                          -80,000

 - Holds                                                            -46,000

     Closing Balance ($Open Opportunities)       844,000


Any Ideas??