Get the latest perspectives on Microsoft Dynamics 365 software selection process from industry experts

Examples of Grouping Information and Records in Microsoft Dynamics CRM

Visit Website View Our Posts

Updated · Originally published

Microsoft Dynamics CRM holds a tremendous amount of information, but it is even more powerful when that information can be easily organized and grouped in the way you want to see it.  Out of the box, you are somewhat limited with what is available in Dynamics CRM, as everything is shown in a list format. You are not able to do complex grouping, sorting, and calculations of information and records... unless you use EditAble CRM Grid for Microsoft Dynamics CRM.

The EditAble CRM Grid is best known for inline editing because it creates an Excel-like interface within Dynamics CRM that allows you to edit records quickly. But this tool also allows you to very easily group records and information and then perform calculations both for the group and for the total level.

For example, a property management company can use Dynamics CRM to look at all the units in the buildings that they manage and group the units by building or occupancy. Then they can see a calculation of the total rents for all the units within each building. All  Dynamics CRM users can quickly look at the page and know, with one glance, how much rent each unit is bringing in and which building it is located in. You can sort, group and calculate the information any way you need to see it.

Another example is an Insurance company that uses an Editable CRM Grid to calculate group insurance rates, such as medical, dental, vision, and voluntary benefits. They can group the different products within those categories. They see a quick snapshot of what they offer their employees as benefits. This has proved to be invaluable.

You can go a step further and associate multiple grids with one another, so changes in sub-grids will update the main summary grid. The possibilities are endless.

How could you use the Editable CRM Grid to group information within your Microsoft Dynamics CRM system?

ForgeXRM + Microsoft

ForgeXRM develops innovative solutions that drive productivity and empower businesses to achieve more with the Microsoft Power Platform and Dynamics 365.

With our deep specialization, industry-leading CRM solutions for Insurance and Wealth Management, and Add-Ons for Project Management and our configurable XRM Grid Control, we accelerate innovation and empower businesses to maximize their CRM investments.

Contact ForgeXRM today. We’d love to connect and learn more about your goals and explore how ForgeXRM + Microsoft can support your organization’s needs.

By Ryan Plourde, ForgeXRM, www.forgexrm.com

Ryan Plourde

By Ryan Plourde, Principle and Owner, ForgeXRM

As Founder of ForgeXRM, I bring 30+ years of experience helping businesses streamline operations and strengthen relationships through CRM/XRM solutions built on Microsoft Dynamics 365 and Power Platform. My focus is on delivering tailored software solutions that solve real business problems, whether you're managing people, products, or processes. Previously, I founded AbleBridge, a leading Microsoft Partner/CRM solutions provider acquired by Crowe LLP, where I led the firm’s Microsoft practice.