My sales force is running a promotion. During a specific range of dates, leads are counted. Each incoming lead is a separate record in my existing database. Each record is attached to a specific salesperson. I have been able to run reports containing sums, and sort them by a date range; but for this latest promotion, my needs have grown more complex. I now need to be able to do the following:
1. Sum leads by salesperson for current week, and for previous week, and calculate improvement over previous week.
2. Store the results of these calculations in a table, or at least display them in a report, where % improvement scores are listed for each salesperson for each week during the life of the promo.
Dates of the promo can be manually set by the database admin.