Creating a PivotTable

You can create a PivotTable from either an Excel range or an external data source. If you’re working from an Excel range, your data should meet the criteria for a well-constructed list. That is, it should have column labels at the top (the headings become field names in the PivotTable), each column should contain a particular kind of data item, and you should not have any blank rows within the range. If the range includes summary formulas (totals, subtotals, or averages, for example), you should omit them from the PivotTable; the PivotTable performs its own summary calculations.

Note

For information about connecting to and querying external data sources, see Chapter 24.

The source range on your Excel worksheet can be a table ...

Get Microsoft® Excel® 2010 Inside Out 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.