From the course: Google Sheets: Pivot Tables

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Create a calculated field

Create a calculated field

- [Instructor] When you change the summary operation in a Google Sheets pivot table, you get a new perspective on your data. Unfortunately there are only a few built in operations you can use, so in this movie, I'll show you how to create a custom calculation to summarize your pivot table data. My sample file is 0106 custom and you can find that in the chapter 1 folder of the exercise files collection. This workbook has two worksheets. The data on sheet one. And then then pivot table on pivot table two. That's the worksheet I'm looking at right now. We're going to create our custom calculation in the pivot table editor. If you don't see it, for example, if you closed it, you can bring it back by clicking any cell within the pivot table. To create a calculated field, or custom calculation within a pivot table, you need to go over to the pivot table editor, and then scroll down to the values area and then I'll go ahead and delete actual from the values area now by clicking the actual…

Contents