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

  • Question

  • 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

  • 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