Skip to Main Content
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
book

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

by Thomas Fragale
May 2024
Beginner to intermediate content levelBeginner to intermediate
304 pages
7h 43m
English
Wiley
Content preview from Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

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.

A picture depicts Q R code.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Bill Jelen

Publisher Resources

ISBN: 9781394243051Purchase Link