# Multiple Goals on single report **URL:** \ **Category:** Dashboards & Reporting\ **Created:** [February 28, 2023, 9:44pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196 "2023-02-28T21:44:30Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![spaulsen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/spaulsen/32/68653_2.png) [@spaulsen](https://community.hubspot.com/u/spaulsen)\ **Post date:** [February 28, 2023, 9:44pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/1 "2023-02-28T21:44:30Z")
Silly question time… again. I have a sales team with a 2 revenue targets that are set up in HS… a minimum quota and a stretch goal… the minimum quota is set up as User goals and the stretch goal is set up as a Team goal How can I show YTD sales with both goals displayed in the same report? Thanks in advance ---
**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\ **Post date:** [February 28, 2023, 11:19pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/2 "2023-02-28T23:19:34Z")
Hello, @spaulsen thank you for posting in our Community! Let’s ask our top experts about this matter: @danmoyle @LVarvashevich @Josh any recommendations to @spaulsen matter? Thank you, Pam ---
**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\ **Post date:** [March 1, 2023, 1:35pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/3 "2023-03-01T13:35:01Z")
If you have Goals set up in your Deals, you **should** be able to a custom report that includes both the sale rep goals and the team goals to show YTD sales. I’d try this: 1. Go to Reports, then _Create a custom report_. 2. Choose “Deals” as the primary data source. 3. Add the “Amount” property to your report to show the total revenue generated by your sales team. 4. Click on filters and select the date range you want to view. 5. Then select “User goal” and choose the minimum quota as the goal type and set the value to “Yes” to filter out the deals that have not met the quota. 6. Add another filter for “Team goal” and choose the stretch goal as the goal type and set the value to “Yes” to filter out the deals that have not met the stretch goal. 7. Save the report and run it to see the YTD sales with both goals displayed in the same report. Hope that helps, @spaulsen! ---
**Author:** ![spaulsen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/spaulsen/32/68653_2.png) [@spaulsen](https://community.hubspot.com/u/spaulsen)\ **Post date:** [March 2, 2023, 8:28pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/4 "2023-03-02T20:28:47Z")
@danmoyle thank you for the info… silly follow up question time… what do you mean by setting the Goals up in Deals? I set them up by going to Settings, then Tracking & Analytics, then Goals I searched Knowledge Base and couldn’t find how to set Goals up in Deals, and it is evidently necessary because I can’t follow your instructions past #4… Can’t find User Goals anywhere. Sorry to such nube and a pain, just trying to gain clarity. Thanks ---
**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\ **Post date:** [March 2, 2023, 8:53pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/5 "2023-03-02T20:53:29Z")
Not silly at all @spaulsen 😊 Follow up questions are always welcome! I’m looking at **[creating goals](https://knowledge.hubspot.com/reports/create-goals)** and **[custom goals](https://knowledge.hubspot.com/reports/create-custom-goals)** in HubSpot sales, and connecting them to the custom reports. I didn’t create a report myself, just leaning on my understanding of Custom Reports and the various objects/properties in HubSpot, and other resources like KB articles. So I can’t gurantee it’s a perfect solution. Just hoping to spark the solution as you’re working through it. ---
**Author:** ![spaulsen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/spaulsen/32/68653_2.png) [@spaulsen](https://community.hubspot.com/u/spaulsen)\ **Post date:** [March 2, 2023, 11:20pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/6 "2023-03-02T23:20:22Z")
Thanks for the help @danmoyle You did point me towards the answer… ![spaulsen_0-1677799161578.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/c/6cbaef9ee487385fda117cb2c6f19dc0e3ed9f22.png) I created one goal (Quota) as User goal and the other (Stretch) as Team goal. Team goals can not be included in reports (see pic) ---
**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\ **Post date:** [March 6, 2023, 2:21pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/7 "2023-03-06T14:21:00Z")
Love that you found it and it was just a small nudge. Happy to help, even if it was a small kernel. Keep exploring @spaulsen! 😁 ---
**Author:** ![spaulsen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/spaulsen/32/68653_2.png) [@spaulsen](https://community.hubspot.com/u/spaulsen)\ **Post date:** [March 2, 2023, 11:24pm UTC](https://community.hubspot.com/t/multiple-goals-on-single-report/76196/8 "2023-03-02T23:24:21Z")
However… the answer was staring me in the face the whole time. I just had to check the box “Include monthly report goal” and set that to a monthly amount that would add up to my annual stretch goal and here’s what I got… ![spaulsen_1-1677799446853.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/8/d8a8dca7efc3fd3f0c6b79f1aabe88990579a8f1.png) my 2 lines!