how to display Total Value (Estimated Revenue) of all the stages (Pipeline phase) of Sales Pipeline for any Sales Pipeline graph in MS CRM.
-
lundi 30 avril 2012 04:24
Hi all,
how to display Total Value (Estimated Revenue) of all the stages(Pipeline phase) of Sales Pipeline for any Sales Pipeline graph in MS CRM.
In funnel chart I want to display the total estimated revenue value of all the pipeline phase.. so how can I achieve this.
Gangadhar
Toutes les réponses
-
lundi 30 avril 2012 10:54
Hi Gangadhar,
Funnel Charts cannot currently display a grand total.
If you are creating this funnel chart as a custom report in visual studio, then add a table above or below your chart. In that table show the grand total using another query.
I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.
Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin: 
- Proposé comme réponse Ashish Mahajan Australia (Architect) lundi 30 avril 2012 10:54
-
mercredi 2 mai 2012 10:11Hi,
If the response answered your question and you are satisfied, please mark the response as an answer and also vote as helpful. This will help others to search on similar problems.
Thanks in advance.Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin: 
-
mardi 22 mai 2012 13:54I wonder if the XML could be edited to include a line chart in another series on the same chart, which would show only the one total and appear at the top?
-
jeudi 20 septembre 2012 15:29
Gangadhar,
The problem with graphing the total with the details is that it will skew the numbers and make your beautiful pie chart ugly. I agree that perhaps an SSRS report that just returns that number, would be the best bet...
BTW, If you want to total fields across child entities, our solution could help: we just built out a new rule type: "Sum Fields Across Children". You specify the field you want to sum, and the field to store the total in, and our plug-in does the is saved. That might make it easier for you to use OOB charts to see summary totals. See http://www.crm-rules.com for more info (later this week, I'll post a YouTube video showing just how this is done...) HTH,
Dave