Getting Data from a Pivot Table: GETPIVOTDATA

A pivot table is the most powerful means of analyzing data available in Excel.

That might sound over the top, but it's true. Consider that a pivot table enables you to

  • View a data field (such as age, weight, revenues, costs, and so on) as a sum, an average, a standard deviation, a count of cases, and seven other types of summary

  • Categorize the records according to many different fields (such as sex, product line, political affiliation, region, and so on)

  • Combine and recombine categories (such as male Republicans, or routers sold from northwest offices) just by dragging a cell

  • Base the pivot table on a list in an Excel workbook, or an external data source such as a database or a data cube

  • Display the data ...

Get Managing Data with Microsoft® Excel 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.