From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Inserting calculated fields

Inserting calculated fields - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Inserting calculated fields

“

- [Instructor] Another really important capability of pivot tables is the option to insert custom calculated fields. Calculated fields basically just allow you to create brand new measures based on any existing numerical fields. So in this case, gone into my analyze tab, into the fields items and sets drop down, selected calculated field. And then from there you have this dialogue box that allows you to give your new field any name you choose and then define a calculation based on any existing fields. So you'll see your field list right here within the dialogue box and you can simply double click items to pull them into the formula. So in this case I've added a new calculated field called percent students that's equal to the student population divided by the total population. Now a very important pro tip on this slide, don't calculate your rate metrics, things like click through rate, cost per click, sales per day, whatever it might be. Don't make those calculations in your raw data…

Contents