# Previous deal stage **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** revenue-analytics\ **Created:** [January 13, 2020, 4:41pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076 "2020-01-13T16:41:49Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Sanjiiv](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sanjiiv/32/2490_2.png) [@Sanjiiv](https://community.hubspot.com/u/Sanjiiv)\ **Post date:** [January 13, 2020, 4:41pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/1 "2020-01-13T16:41:49Z")
Hi, I’d like to create a report to show where deals were before they were marked as lost. E.g. 10 deals were marked as lost pre-trial, 5 were lost post-trial, etc. Is there any way to do this without having to click into each individual deal to see what stage the deal was at before being marked as lost? Thank you in advance. ---
**Author:** ![DanielSanchez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danielsanchez/32/48193_2.png) [@DanielSanchez](https://community.hubspot.com/u/DanielSanchez)\ **Post date:** [January 13, 2020, 5:44pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/2 "2020-01-13T17:44:10Z")
Hi @Sanjiiv , In Reports \> Dashboard. Click in Add Report, and filter by Deals. In this section, u have many reports of deals, how “Deal totals by stage” or “Deal stage funnel with deal totals and conversion rates”, and others reports. I believe with Funnel with deals and conversion rate, is possible where you was lost the deals, to improve. Did this post help solve your problem? If so, please mark it as a solution. Best regards! 🙂 ---
**Author:** ![HubSpotMaster](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hubspotmaster/32/31853_2.png) [@HubSpotMaster](https://community.hubspot.com/u/HubSpotMaster)\ **Post date:** [January 13, 2020, 7:03pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/3 "2020-01-13T19:03:53Z")
I recommend taking the following steps - Add “Last Deal Stage” Property with a drop-down of all your active stages (not closed won or lost). - Create a workflow to update this deal stage whenever the deal stage is updated to another active deal stage. - Create a report that shows the last deal stage before closed lost. Let me know if this works out for you! Thanks, Adam ---
**Author:** ![orianef](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/orianef/32/21752_2.png) [@orianef](https://community.hubspot.com/u/orianef)\ **Post date:** [January 30, 2020, 11:14am UTC](https://community.hubspot.com/t/previous-deal-stage/18076/4 "2020-01-30T11:14:41Z")
Hi Adam, I have tried to create a Last deal stage property but it appears as a number and does not copy properly the name of my deal stage as it is a radio select ? Thank you for your help! Oriane ---
**Author:** ![LLW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/llw/32/31184_2.png) [@LLW](https://community.hubspot.com/u/LLW)\ **Post date:** [May 25, 2020, 10:53pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/5 "2020-05-25T22:53:28Z")
Hi! This solution is great for the reporting problem I am trying to solve. I am trying to set up the workflow as suggested but I am struggling with how to set up this particular workflow. Any advice? Thanks! Leah ---
**Author:** ![Tiff](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tiff/32/58551_2.png) [@Tiff](https://community.hubspot.com/u/Tiff)\ **Post date:** [August 20, 2020, 1:09pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/6 "2020-08-20T13:09:58Z")
did you manage to work this out Leah? I am trying to do one now and can’t work out where to start with the workflow ---
**Author:** ![LLW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/llw/32/31184_2.png) [@LLW](https://community.hubspot.com/u/LLW)\ **Post date:** [August 20, 2020, 2:45pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/7 "2020-08-20T14:45:06Z")
Apologies I couldn’t work it out and I haven’t been given any advice since I posted! Hopefully the activity will mean it gets noticed! ---
**Author:** ![Tiff](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tiff/32/58551_2.png) [@Tiff](https://community.hubspot.com/u/Tiff)\ **Post date:** [August 20, 2020, 3:27pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/8 "2020-08-20T15:27:57Z")
I sort of worked it out but it will only work once a deal moves into a non active deal stage. So I did a workflow that updated the Last deal Stage property to whatever the current deal stage was but only using live stages in the dropdown. I used the enrollment as deal stage has been updated in the last 1 day and then did if/then branches to cover each stage. So for example if deal stage is Qualified update last deal stage to qualified. As long as you don’t use the closed won or lost stages in the last deal stage properties it will work but only when it gets to one of those stages. Hope that makes sense? In an ideal world i would have got it to work on historic deals but it doesn’t so I still can’t report on what I want. I have raised it with my Hubspot AM so if I get an answer I will let you know ---
**Author:** ![LFujimoto](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lfujimoto/32/13631_2.png) [@LFujimoto](https://community.hubspot.com/u/LFujimoto)\ **Post date:** [January 5, 2022, 11:30pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/9 "2022-01-05T23:30:13Z")
I created the property “last deal stage” and used the “automation” funtionality on the pipeline to register this information. Hope it works! Settings \> Objects \> Deals \> Pipeline \> Automation ![LFujimoto_0-1641425352631.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/c/c5a39e1e5f52f13e85ac4e1cf1afab03c59d3d48.png) ---
**Author:** ![Nadav\_Attar](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nadav_attar/32/5917_2.png) [@Nadav\_Attar](https://community.hubspot.com/u/Nadav_Attar)\ **Post date:** [July 18, 2021, 4:14pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/10 "2021-07-18T16:14:14Z")
Hey Adam, I trying to build the Workflow but got stuck. think you can help with this? ---
**Author:** ![MMatos2](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@MMatos2](https://community.hubspot.com/u/MMatos2)\ **Post date:** [October 9, 2023, 2:09pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/11 "2023-10-09T14:09:17Z")
What would this look like? “Create a workflow to update this deal stage whenever the deal stage is updated to another active deal stage.” ---
**Author:** ![gelflex-cc](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gelflex-cc/32/25042_2.png) [@gelflex-cc](https://community.hubspot.com/u/gelflex-cc)\ **Post date:** [January 13, 2020, 8:31pm UTC](https://community.hubspot.com/t/previous-deal-stage/18076/12 "2020-01-13T20:31:01Z")
@Sanjiiv I live @HubSpotMaster idea a lot. Hope this helps. ---
**Author:** ![MaorL](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/maorl/32/66300_2.png) [@MaorL](https://community.hubspot.com/u/MaorL)\ **Post date:** [May 26, 2023, 1:44am UTC](https://community.hubspot.com/t/previous-deal-stage/18076/13 "2023-05-26T01:44:10Z")
Good Idea. Here is how i’ve solved it I’ve created 2 single line text fields. 1. Deal Stage Buffer 2. Previous Deal Stage Then I built workflow to set the real deal stage to the buffer property but only after I’ve copied the content from buffer to Previous Stage property Goodluck ![MaorL_0-1685065430224.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/2/2250ec9b1b3507fff3d697308b94e4663ec3cba4.png)