CHAPTER 30
Analyzing Data with PivotTables
The previous chapter introduced PivotTables. There we presented several examples to demonstrate the types of PivotTable summaries that you can generate from a set of data.
This chapter continues the discussion and explores the details of creating effective PivotTables. Creating a basic PivotTable is easy, and the examples in this chapter demonstrate additional PivotTable features that you may find helpful. We urge you to try these techniques with your own data. If you don't have suitable data, use the files available on this book's website.
Working with Non-numeric Data
Most PivotTables are created from numeric data, but PivotTables are also useful with some types of non-numeric data. Because you can't sum non-numbers, this technique...
