Ross D. Personally, if purchasing another tool is not an option, I would clean up historical data.
Generally speaking, I would take all closed won deals, sum up the total by company and close date, and then update a single opportunity.
Once I have the previous contracts closed won deal amount corrected, I would use a workflow + formula to calculate uplift on the new deal record.
