CHAPTER 4Summarizing Data

In previous chapters, you used a pivot table to summarize insurance policy data and reported on the grand total of insured value by region and by building construction type. In most of the reports, you showed a total sum, and in one report you changed the report so it showed a total count of the policies sold. In this chapter, you'll use different data to create a pivot table, and you'll explore other ways of summarizing the data. You'll work with the grand totals and subtotals in the pivot table and learn how to group the data for a range of numbers or dates.

Exploring a Work Orders Example

To follow the examples in this chapter, download and open the sample file named WorkOrders_01.xlsx, available at ...

Get Beginning Pivot Tables in Excel 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.