# Report Closed won vs Closed Lost

**URL:** <https://community.hubspot.com/t/report-closed-won-vs-closed-lost/27034>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [October 21, 2020, 9:45am UTC](https://community.hubspot.com/t/report-closed-won-vs-closed-lost/27034 "2020-10-21T09:45:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Semora](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/semora/32/98997_2.png) [@Semora](https://community.hubspot.com/u/Semora)\
**Post date:** [October 21, 2020, 9:45am UTC](https://community.hubspot.com/t/report-closed-won-vs-closed-lost/27034/1 "2020-10-21T09:45:18Z")

</div>

Hi,

I’m a super newbie in HubSpot and am building our Sales Pipeline Dashboard.

Within this dashboard, I want to have the report which shows me the amount of “closed won” deals vs. “closed lost” incl. revenue.

Can anyone help me out?

Thanks!

---

<div class="post-metadata">

**Author:** ![JessicaH](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jessicah/32/14826_2.png) [@JessicaH](https://community.hubspot.com/u/JessicaH)\
**Post date:** [October 22, 2020, 7:57am UTC](https://community.hubspot.com/t/report-closed-won-vs-closed-lost/27034/2 "2020-10-22T07:57:40Z")

</div>

Hi @Semora,

Thanks for reaching out.  
I want to tag in some subject matter experts to see if they have any suggestions.  
Hi @ElyshaShave @AM8 @AmyDwyer, do you have any thoughts on this?

Thanks!

Jess  
Thanks!  
Jess

---

<div class="post-metadata">

**Author:** ![AmyLou](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amylou/32/25859_2.png) [@AmyLou](https://community.hubspot.com/u/AmyLou)\
**Post date:** [October 22, 2020, 2:01pm UTC](https://community.hubspot.com/t/report-closed-won-vs-closed-lost/27034/3 "2020-10-22T14:01:19Z")

</div>

Hi @Semora,

Not sure if this is exactly what you’re looking for but I was able to edit the Deals Total By Stage Report to show just Closed Lost and Closed Won. Unfortunately, my demo data didn’t have any Closed Lost so the graphic isn’t what you’re looking for, but if you have Closed Lost it would be a separate column.

This is how I did it.

Add Report \> Deals \> Deals Totals in Stages\> Edit in Builder

I filtered by Deal Stage: Closed & Won

See the attached pics of the other settings I used.

 ![33435iAC7E637D311D1324.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/6/d63d18ab805204e95dd26839b832290978b50a1a.png)

 ![33431iF9B3FDEADB5E7960.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/c/6c9c865666826cbb46b3402b0c80cfa0d3b4d6e3.png)

 ![33433i63505855314EB89E.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/1/71095f3353b0579a74f47cb1e853072305a5a5b3.png)

 ![33434iB7431B5ED313122B.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/5/b5745eb17aa43c8c2ed066c4f70d39dbf6ebf51e.png)

Hope this helps. Please don’t hesitate to ask me if you have any other questions.

Kind Regards

Amy-Louise

_Senior Business Analyst_

[MethodData](http://www.methoddata.com)

---

<div class="post-metadata">

**Author:** ![HHammoud](https://avatars.discourse-cdn.com/v4/letter/h/ecae2f/32.png) [@HHammoud](https://community.hubspot.com/u/HHammoud)\
**Post date:** [December 23, 2021, 11:41am UTC](https://community.hubspot.com/t/report-closed-won-vs-closed-lost/27034/4 "2021-12-23T11:41:57Z")

</div>

I couldn’t find the deals part after the add report click!