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.
