From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

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

Value calculation modes

Value calculation modes - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial Buy for my team

Value calculation modes

“

- [Instructor] Alright next up we have something called show values as. And this is one of the single most powerful and important capabilities that pivot tables have to offer. So take notes, pay attention, this is really important stuff. You'll find the show values as menu right beneath the summarized values by options that we just talked about. Basically what show values as options do is they allow you to provide additional layers of calculations that change the way you view the numbers based on your pivot table view. So it's important to distinguish this from the summarized values options that we just talked about. So think of it this way, summarize actually determines how the actual core numbers are calculated as their aggregated. So as a sum count average min max, by contrast the show values as options allow you to look at those numbers and display those numbers through all sorts of different lenses to add more insight. So in this case here in the screenshot we're looking at…

Contents