From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

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

Calculating using counts, part 1

Calculating using counts, part 1 - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Calculating using counts, part 1

- [Instructor] Alright time for another pro tip and this one's about using calculated fields with counts. And if you recall in the intro lecture about calculated fields, I mentioned that any metric that's included in a calculated field calculation will be evaluated as a sum by default. There's actually a way around that, and I'm going to show you how it works. So first things first let's adjust our pivot here. Instead of data by country let's pull in data by rating. And only filter down to G, PG, PG-13, and R. And there you go, we can pull out profit, we can pull out ROI, those are the calculated fields that we had created. Keep in mind that they are still here available for us if we choose to use them later they don't disappear. And we're going to look at gross revenue. So looking at this view here we still have the five year time frame selected and we're looking at total revenues broken down by ratings. So looking at this view you may be tempted to say that PG-13 movies perform…

Contents