Report Filter "Goal"

La___Carla
Member

Hey community! 

 

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?

La___Carla_0-1709746495152.png

 

0 Upvotes
1 Accepted solution
trevordjones
Solution
Recognized Expert | Diamond Partner
Recognized Expert | Diamond Partner

HI @La___Carla ,

 

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.

 

Trevor Jones

Consultant II

Process Pro Consulting
mobilePhone
(207) 939-7689
emailAddress
tjones@processproconsulting.com
website
processproconsulting.com
address
Remote from Maine
linkedin

View solution in original post

1 Reply 1
trevordjones
Solution
Recognized Expert | Diamond Partner
Recognized Expert | Diamond Partner

HI @La___Carla ,

 

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.

 

Trevor Jones

Consultant II

Process Pro Consulting
mobilePhone
(207) 939-7689
emailAddress
tjones@processproconsulting.com
website
processproconsulting.com
address
Remote from Maine
linkedin