From the course: Excel: Mastering Pivot Table Dashboards and Reports
Join today to access over 24,700 courses taught by industry experts.
Running totals - Microsoft Excel Tutorial
From the course: Excel: Mastering Pivot Table Dashboards and Reports
Running totals
(chiming music) - Okay, so now I'm going to show you how to build running totals in your data set. So, what we're going to do is over here I'm going to insert a new pivot table. So G5, Insert, Pivot Table, like that. Orders right here. So that references the correct table. Okay, so watch this. We need to get access to the month and the year of order date. So it's not always so easy. I'll show you the way that I like to get it. I'm sure there's the other pivot table gurus, John Michaloudis, my buddy, Ken Puls, that they would not like this way but this is the way I like to do it, okay? So I'm going to drop Order Date over here. You see that I've dropped Order Date in here and now it has these groups, right? Okay, so I've dropped Years in Order Date over here and you see it put these years up here. So I'm going to take this right over here and I'll put the order date, now that I already have the years in here…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.