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: Running Total

Show Values As: Running Total - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Show Values As: Running Total

“

- [Instructor] All right, so we talked about how difference from and percent difference from can be a great way to analyze time series data. One thing that I want to call out before we move on is the fact that the difference from calculations use what's called positional references, meaning that these calculations are specifically based on the structure and order of these relative fields, genre and years. And because they use positional references, it does limit some of the sorting options that it otherwise would have had. So, for genre, if I wanted to sort these descending by gross revenue, I'm no longer able to do that because I'm using custom calculations, in this case my difference from and percent difference from calculations that use positional references. So, when you run into this error, it may limit you from doing some of the sorting options that you could have done otherwise. So you may need to do any sorting that you need to before applying or adding these custom…

Contents