I am trying to create a report that shows my goal and the actual deals closed in € to check my progress. I'd like to do this for all of my team members, so we can see how each of us is doing. However, I cannot filter for my goal. No matter what I type in, it always says "No results found". Has anybody got an idea, why?
Report filters currently pull from properties of the associated records (in this case, a deal) and unfortunately your goal is not a property on a deal record. As of right now there is no way to filter Deal reports based upon goals.
However, there is a way to check your progress against your goal. If you click on Reports > Sales > Forecasts and Pipelines > Quota Attainment you can see a report that will show each rep's sales as a bar graph, with their quota as a line on the bar graph. You can filter this bar graph by salesperson, using "Me" as the filter so it always filters to the current user, then save it to use on a dashboard. You can then email this dashboard out to yourself and your teammates on whatever frequency you like.
- Trevor If my post solves your problem, please accept it as a solution.
Report filters currently pull from properties of the associated records (in this case, a deal) and unfortunately your goal is not a property on a deal record. As of right now there is no way to filter Deal reports based upon goals.
However, there is a way to check your progress against your goal. If you click on Reports > Sales > Forecasts and Pipelines > Quota Attainment you can see a report that will show each rep's sales as a bar graph, with their quota as a line on the bar graph. You can filter this bar graph by salesperson, using "Me" as the filter so it always filters to the current user, then save it to use on a dashboard. You can then email this dashboard out to yourself and your teammates on whatever frequency you like.
- Trevor If my post solves your problem, please accept it as a solution.