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.

Value summarization modes

Value summarization modes - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Value summarization modes

“

- [Instructor] Alright, welcome to section five, Calculated Values and Fields. Now we're really starting to cruise, we're really starting to unlock some of the true, analytical potential of pivot tables. We started to get there with sorting and filtering tools, which can be really valuable, but calculated values and fields, this is where we're going to be creating brand new metrics. We're going to be customizing how we're showing and calculating values in our tables, and we'll really start opening the door for some much more advanced and creative analysis. So let's start simple with summarizing values. In every pivot table value field, there's a "summarize values by" option, and this determines how numbers should be treated when they're rolled up or aggregated. So let me give you an example. So far in this course, we've been spending a lot of time focusing on budgets and revenues for movie titles, and those titles can be rolled up or aggregated at higher levels, by genre or by…

Contents