CHAPTER 3Using Calculations in Pivot Tables
In Chapter 2, “Summarizing and Presenting Data with a Pivot Table,” the pivot table you built displays either a sum or a count for the field you have in the Values section of the PivotTable Fields window. If the field being used in the Values section of the PivotTable Fields window contains any text or date values in the column from the original data, the calculation will default to a count. If the field being used in the Values section of the PivotTable Fields window contains all numbers in the column from the original data, the calculation will default to a sum. You can see the calculation that is used by looking at the Values section of the PivotTable Fields window or by looking at the top‐left corner of the pivot table. Of course, as you will learn in this chapter, you can add more calculations to the pivot table or change the calculations that are already there.
Using Built‐In Calculations in Your Pivot Table
It is time to explore the many other calculations that are available in pivot tables. These calculations allow you to summarize and analyze your data in many ways. There are numerous calculations that are built in, and there are calculations that you can create. Let's start with the calculations that are already part of the pivot table.
Get Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot 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.
