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.

Show Values As: Index

Show Values As: Index - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Show Values As: Index

“

- [Narrator] Alright, now the last show values as calculation that I want to share with you guys is one called index, and this is by far the most mysterious calculation. It's a bit more complicated than the other calculations and as a result a lot of people never even use it. So allow me to clarify exactly what the index calculation is used for and how you might be able to apply it in different ways. So in our PivotTable, let's go ahead and pull out this rank calculation that we created in the last lecture and instead of looking at data by year, I'm going to pull years out into the filters column and I actually want to look at a five-year sample of data, so I'm going to select 2011 as well. Press OK, and now I want to look at a two-dimensional view of this data. So instead of just by genre, I want to also compare by country as columns. But instead of all of these columns where you have a lot of really low-volume countries mixed in here, it's just kind of adding noise, so I'll apply a…

Contents