
Hi! I want to create a ssrs report that displays the convertion rate on leads to signed opportunity. I am online and use FetchXML
To achieve this I need to sum all closed leads and all closed opportunities and divide this on won opportunities.
I figure I need two datasets in the report (oppty and lead). Will it be possible to sum this and then make the calculation?
What is the best way to approach this task?
Many many thanks for help!
*This post is locked for comments
I have the same question (0)it would be similar to the OOB Lead Source Effectiveness Report, but with my own parameters