Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Is it possible to aggregate (SUM) two fields from two entities for charting and reporting? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Is it possible to aggregate sum two columns using Fetch XML? for instance the Estimated Revenue from Leads and the Estimated Revenue from Opportunities?

    One of our customers would like a chart and report based on the aggregate value.

    Thursday, November 21, 2013 2:36 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Take a look at this article it demonstrates similar functionality but using Opportunity and Campaigns. You should be able to use this example to accomplish what you are looking for.

    http://crmchartguy.wordpress.com/2013/08/08/advanced-campaign-performance-chart-in-ms-crm/

    Thursday, November 21, 2013 3:30 PM