5. Performing Calculations in Pivot Tables
In This Chapter
Introducing Calculated Fields and Calculated Items
Understanding the Rules and Shortcomings of Pivot Table Calculations
Introducing Calculated Fields and Calculated Items
When analyzing data with pivot tables, you will often need to expand your analysis to include data based on calculations that are not in your original data set. Excel provides a way to perform calculations within a pivot table through calculated fields and calculated items.
A calculated field is a data field you create by executing a calculation against existing fields in the pivot table. Think of a calculated ...
Get Excel® 2016 Pivot Table Data Crunching 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.