I have a .csv list of companies that I have been monitoring in Salesforce and would like to view the most recent opportunity. Is there a way to generate a report that compares a customized company list to closed opportunities?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
How many companies are in the list? If it is just a handful, you could:
This would be the least painful method I imagine, but doesn't scale very well if it is a large number of companies or there have been a lot of closed opportunities that would bloat your report.
reporting on accounts and their most recently closed opportunity
filtering the list of accounts in the report
You could certainly filter by account name as Michael suggested but that isn't really scalable and you will hit the filter criteria length limit pretty quickly. I would recommend creating a checkbox field on the account as a flag to determine whether it should be in the report.
If you have the account ID or an external ID in your csv you could use it to quickly set the checkbox to TRUE on all those accounts with the dataloader or just use a listview and go through and mass-edit the checkbox on the appropriate accounts.