# Pipeline x Win Rate

**URL:** <https://community.hubspot.com/t/pipeline-x-win-rate/81795>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [May 23, 2023, 1:46pm UTC](https://community.hubspot.com/t/pipeline-x-win-rate/81795 "2023-05-23T13:46:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EmilyHamilton](https://avatars.discourse-cdn.com/v4/letter/e/f17d59/32.png) [@EmilyHamilton](https://community.hubspot.com/u/EmilyHamilton)\
**Post date:** [May 23, 2023, 1:46pm UTC](https://community.hubspot.com/t/pipeline-x-win-rate/81795/1 "2023-05-23T13:46:19Z")

</div>

Good Morning!  
I have a sales team performance dashboard in my system. This is a series of reports for each one of my sales reps.

Currently, these are the report filters:

- Deal Stage = Won, Lost
- Date Property = Last Modified Date
- Date Range = Rolling date range, Last 365 days
- Deal Owner = John Walker

I need to find out how to take the total revenue of all deals currently in the stage “sent to the customer” x the reps ALL TIME win average. How is this possible?

---

<div class="post-metadata">

**Author:** ![MiaSrebrnjak](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/miasrebrnjak/32/10_2.png) [@MiaSrebrnjak](https://community.hubspot.com/u/MiaSrebrnjak)\
**Post date:** [May 24, 2023, 10:05am UTC](https://community.hubspot.com/t/pipeline-x-win-rate/81795/2 "2023-05-24T10:05:57Z")

</div>

Hi @EmilyHamilton,

Thank you for reaching out to the Community!

I wanted to tag in a couple of subject matter experts to see if they have any advice:

Hi @ChrisoKlepke, @deepikaverma, @franksteiner79, do you have any tips for @EmilyHamilton? Thank you!

Cheers  
Mia, Community Team