All Collections
Getting Started with Prospect CRM
Summarising & Adding Grouping to your Report
Summarising & Adding Grouping to your Report

This article will outline how to summarise and add grouping to your CRM Report.

Isobel Honour avatar
Written by Isobel Honour
Updated over a week ago

Adding a Summary and Grouping to a CRM Report can help you analyse your data in more depth for further insights. 

Difference between Summary & Grouping

Summary

A Summary will display a count of your chosen field at the top of the Report. The Summary can display the Total, Minimum, Maximum, Average and Unique Values. 

Grouping

Grouping will change the display of the Report and group the data based on your chosen field. Please note: you can also add summaries to these individual groups on the Report. 

Adding a Summary

Step 1: Further Options on Report

Once you've chosen/built your Report within the CRM, and have applied the appropriate Filters, click on the further options icon (three dots) and select 'Grouping and Summary' from the drop-down.

Step 2: Choose Summary Option

On the left-hand side, a tree like view will display all of the related fields that you could use for your Summary. For example, you may wish to summarise the Report by Opportunity Value. 

Drag and drop the field you wish to summarise into the drag and drop area. Please note: you can add more than one Summary on a Report.

Step 3: Choose Summary Display

You'll then be able to choose what type of Summary you'd like to display on the Report using the options from the drop-down list e.g. Total or Average. 

Once happy with your selection, click 'Submit' in the top right-hand corner. This will then display your new Summary at the top of your Report, along with the count if you've it selected as well (simply tick the box 'Show Count' to show this too). 

Adding Grouping

Step 1: Further Options on Report

Once you've chosen/built your Report within the CRM and have applied the appropriate Filters, click on the further options icon (three dots) and select 'Grouping and Summary' from the drop-down.

Step 2: Choose Field to Group By

On the left-hand side, a tree like view will display all of the related fields that you could use as a Group. For example, you may wish to group the Sales Transaction Report by Account Manager. Drag and drop the field you wish to group the Report by into the drag and drop area. You'll then have the option to also summarise the groups by dragging and dropping the required field. For example, you may wish to summarise the groups by Base Line Value.

Please note: you can also click on the sort icon on either the group field or the summary field to display the groups/summaries in the desired order. For example, you could order the Report by Base Line Value summary to see which Account Manager has made the most sales!

Once happy with your selection, click 'Submit' in the top right-hand corner. This will then display your new groups in the Report, along with the summary if one has been set.

Step 3: Adding Multi-level Grouping

You can also apply additional levels of grouping to a single Report by dragging and dropping any additional groups into the 'Groups' section. This will essentially create a Group within a Group. For example, the example Report below is a Sales Transactions Report, grouped by Account Manager, but we can easily apply a second level Group of Industry to understand which industries each Account Manager looks after.

Once additional groups have been added, click 'Submit' to apply the changes.

Did this answer your question?