You have some core reports that reference the same criteria over and over, right?
Like you've got this in 37 reports and views:
What happens if you need to add another Lead Source?
You gotta edit every one of those criteria in every report and view?
No! Use a formula field in your criteria!
By adding another layer, you'll enable yourself to be able to edit the formula field only, and it will logically allow all your reports to move fluidly over without you having to do anything.
- a formula field on the opportunity called "Lead Source Type"
- Change all your reports' criteria (for the last time) to reference this new field instead of "Lead Source"
Use the CASE() formula function to set the value for the Lead Source Type formula:
"Email Campaign", "Marketing",
"Trade Show", "Marketing",
..and so on... "Referral Partner", "Channels",