Summary Report Formats

Sometimes you are uninterested in the details of a report, and want summary information.  This lesson will teach you the different summary formats.

The different Summary Formats

The different Summary Formats

Choose the report you want to work with, and then hit Customize to get the Customize Report Window.  From the Preview Menu with your sample data, you have three Report Formats to choose from.

-  Tabular

-  Summary

-  Matrix

 

Tabular Format

Tabular Format

Tabular is all the details.  This is the most comprehensive view of information.  WHen you run the report, you get a row of information for every item in the report.   If the report is volunteer opportunities, occurrences and connections, for example, you'll get a row for EACH connection.   Which means the opportunities may show up many times in each row.

Summary Format

Summary Format

What if you would like to summarize information by a certain field,  Let's say, we want to summarize these field by if they were managed by Affiliate or Managed by the Partner.  I can do that with this format.  We will show you HOW to do this in the Using Summaries Training.

Summary Format: Advanced

Summary Format: Advanced

You can continue to Summarize information by adding Summaries IN summaries.  In this case, I have a report that summaries the Opportunity City, then the Opportunity names, and has the Occurrence Detail below it.

I can hide the details of the Summary Report

I can hide the details of the Summary Report

If I am uninterested in the individual records, I can hide the details to get some basic information on the Summary of these field by using the Show Button and un-checking the Details.  We will talk about Drop Zones Later

Matrix Format

Matrix Format

You can use Matrix Format to see a Grid of Two or more Summaries.    In this case, I am looking at the summaries of Volunteer Opportunity Names along the Y axis and the Populations served along the top.  Notice there are row Grand Totals, and at the bottom there is a Column Grand Total.

Matrix Format: Advanced

Matrix Format: Advanced

You can continue to add more summary rows and columns using the Customize Report Window

Advanced Users

Salesforce.com has wonderful training and support material that can help you find specific HOW TOs on some of the more advanced Summary and Filter functions.  

Check it out here: Reports in Salesforce: Summary Formats

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.