Report showing weekly deal value in one stage of the pipeline by sales rep

[CAusten]

Hi all,

We have 3 sales reps and I want to create a report that shows the total deal value that each of them is producing at our proposal-issued stage each week. So that we can track that against deal value signed each week per sales rep. 

Any help would be much appreciated. Thanks

[karstenkoehler]

Hi @CAusten,

This can be achieved with a single object report: Menu > Reports > Report > Create report > Single object > Deals

Once in the editor, configure it like shown below:

(Replace the stage with your proposal issues stage and change the date range to your liking.)

Let me know if you have any follow-up questions!

[CAusten]

Hi Karsten,

Thanks for your response. I'm not getting the option to change the frequency as you can see below. I'd ideally like to see time on the x-axis, and amount on the y-axis. Then a bar for each week with the total pipeline deal value, and each bar broken down by colour to show the contribution of each deal owner. Is that possible?

[karstenkoehler · Accepted solution]

Hi @CAusten,

Have you set up your report exactly as shown in my screenshots above? For the frequency dropdown to appear, you must have the date property on the x-axis.

Best regards

[CAusten]

I should never have doubted you. Thanks for your help my friend. 

[karstenkoehler]

Hahaha, @CAusten – glad you have the report that you were looking for.