From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

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

Inserting calculated items

Inserting calculated items - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial Buy for my team

Inserting calculated items

“

- [Instructor] So in the PivotTable analyze options, you may have noticed that, in addition to calculated fields, there's also an option for calculated items. Now, the difference between the two, is that calculated fields are built on numerical variables, while calculated items are built on non-numerical dimensions or categories. So, in a nutshell, calculated items allow you to create new dimensions or categories, using formulas built on existing dimensions and categories. So for instance, if you have movie ratings, like G, PG, PG-13 and R, and you want to create a new category called Kids, which is equal to all of the G ratings, combined with the PG rating data, you can do that using calculated items. Now pro tip, big bold red text here, don't use calculated items unless you absolutely need to. I'm going to be honest, I am not a fan of calculated items at all, they're finicky, they're dangerous, in many cases they're not the most efficient way to accomplish simple tasks. 99.9% of the…

Contents