Microsoft Dynamics CRM 2015 new functionality: How to do aggregate and calculate rollup data

By - December 22, 2014

Microsoft Dynamics CRM 2015 was released for online and on-premise on December 1, 2014, and out-the-box, it has some neat functionalities. In this blog post, I will be concentrating on how to set up rollup field in Microsoft Dynamics CRM 2015.

In the past, if we wanted to do a sum or rollup of all associated opportunities amounts to a related Account, we would need a developer to create complex code or a plugin. However, with Microsoft Dynamics CRM 2015, you can do this using out-the-box user interface.

Business Scenario – The Account manager wants to see the total estimated revenue from all related open opportunities on related account.

Step 1: Go to Setting > Customization > Account > Main Account Form > Add new Field

MSFT Dynamics 2015 Functionality 1

Under Data Type > Select Currency

Step 2:  Under Field Type > Select Rollup

MSFT Dynamics 2015 Functionality 2

Step 3: Click “Edit” on the right of field type from above screenshot.

You should now see this Rollup Field Configuration page.

For related entity > select Opportunities (Potential Customer)

Filters: If Est.Rev contains data

And Status is Open (I only want to sum Est.Rev for Open Opportunities)

Aggregation > SUM

So when you finished configuring your rule, it should looks similar to the screenshot below.

MSFT Dynamics 2015 Functionality 3

Step 4: Add the Rollup Field to the Account form > It should have a little calculator icon next to the field to indicate it is a calculated field and locked.

MSFT Dynamics 2015 Functionality 4

Step 5: Here we have two related Opportunities totaling $16,000 for this account.

MSFT Dynamics 2015 Functionality 5

However, we only want the Open Opportunity and not Won Opportunity.


MSFT Dynamics 2015 Functionality 6

Next, Click the recalculate icon and you should see $10,000 in our new Total Estimated Revenue


MSFT Dynamics 2015 Functionality 7

There you have it, aggregating data from child records to the parent record without the need to code.

There are some limitations on this particular rollup data field. You can read them here in this Microsoft article about rollup field.

In my opinion, this is a very useful and most requested functionality since Microsoft Dynamics CRM 4.0. It was a long wait and Microsoft finally heed our call to add this functionality out-the-box. Microsoft Dynamics CRM 2015 is released, and if you want to know how to upgrade to the latest CRM version, RSM offers a full range of Microsoft Dynamics CRM services from upgrades and implementation to development and support. Contact our professionals for more information on our services at 855.437.7202 or

By: Hien Tieu – New Jersey Microsoft Dynamics CRM partner

Receive Posts by Email

Subscribe and receive notifications of new posts by email.