Creating a summary

So far in this course, I have created reports that display each of the rows that are available …in the source table. …If all you need for your purposes is a summary of that data, you can create a summary function …and add it to your report. …I will show you how to do that in this movie. …To create a summary, you need to have a report with some numerical data, and I have that here. …I have a set of calls for quarters in the year 2011 and 2012 for a series of call centers. …What I want to do is summarize the call data.…

To do that, I'll open the Insert menu and click Summary. Then in the Insert Summary dialog …box, I can select the field I want to summarize, …so I click the top control and click Sheet1_ Calls. Then I can select an operation to calculate …the summary, and I'll just stay with the Sum, but I'll show you the list of other operations …that you could use, and there are quite a few. …Now I can select the type of summary that I want to create. …I can have a grand total, which will go into the report filter, but what I actually want …

Resume Transcript Auto-Scroll

Author

Released

5/31/2012

This course shows business analysts how to use SAP Crystal Reports 2011 to analyze and summarize data to make better decisions. Author Curt Frye teaches how to maximize the power of Crystal Reports and import and analyze data from a variety of places, including Excel, Access, HTML/XML files, and more. The course also shows you how to define and manage reports, summarize data, visualize data using charts, focus analysis by selecting which data a report summarizes, export report data, and connect to external data sources.