Chapter 9: Adding Summaries to Your Reports

Overview

So far, you've learned to filter, group, and sort your report data with the best of them. Yet perhaps more important than all of these is the ability to summarize data — in other words, to provide your report users with the bottom line. This is especially true of reports that use numbers.

In this chapter, we learn about adding calculations such as grand totals, subtotals, percentages, and averages to your report — information that emphasizes a summary and not the detail of the report.

As you delve further into the report-writing world, you'll find that most financial reports require the use of some (and probably all) of these types of summary calculations.