Using Summaries and Grouping Fields in a Report
In this lesson we will learn how to Summarize and Group information for a clearer report.
Navigate to the Report you want to work on, and open the Customize Report Window
I am working with a report that contains the objects: Connections, Occurrences, and Opportunities, where Connections is the most detailed information. Note the field that I have in the report.
Getting to know Drop Zones
Do you remember how easy it was to add columns to a report? Summarizing uses the same drag and drop method. If you want to summarize by a field, you grab it and drop in the drop zone. In this case, I am going to grab the Field Header of Contact and drop it in the Drop Zone. Note that the Green Check Box appears when I am in the Drop zone. Release your mouse.
Note your new Summary
The blue bar shows that we are summarizing by the field Contact (from the Connections Object). The details show the Start and Date time of the Occurrences, and the Name of the Opportunity. Also note that a record count has been included in the Summary. The count is of the most detailed information... in this case, it would be Occurrences, and not Opportunities
Hide the Details of your Summary
Add Another Summary
Let's add another summary under each Contact of the Opportunity. You see, we have another drop zone which allows us to summarize further. Grab the Opportunity name and drop it here. When you have dragged the field to the right place, the drop box turns blue, and the Green Check Box appears for the field.
Salesforce has an extensive knowledge base for Reports and Reporting Summaries in their Help and Training Section.
For more information see: Salesforce Help and Training: Summaries