Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you like to use pivot tables to analyze data, you're going to like this next new feature that allows you to filter via a timeline. It's called the Timeline Filter. We're going to use this file named, No Obstacle Sport - July 2012 Sales Report, which as you can see from the very first Data sheet here is a list of sales for each of the days in July. So, we have multiple sales on the first of July. You can see the SKUs for the items, their prices, and if we scroll all the way down to the bottom of this sheet, we're going to see a grand Total Revenue for the month of July 2012.
This is a perfect opportunity for a pivot table that will help us to analyze that data and make it a little bit easier to understand. Let's go to the Pivot Tab where a pivot table has already been created based on two fields. As you can see we have the Date field and we have the Sum of the Price field next to it. So, instead of individual sales, we see the total sales for the first of July, the second, and so on. And as we scroll down, there's our Grand Total. That's for each of the days in July where there were sales, and if wanted to analyze that further by date, we can use this new Timeline Filter.
All we need to do now is make sure that we're on cell A2. Click there. That's the beginning of our Pivot table. Go to the Insert Tab, and next we'll go to the Filter section where you'll find the new one called Timeline. We'll give that a click and there's only one Date field or table to choose from here. If there were multiple tables, we could select the table we want to base our timeline on, but there's just this one over here. It's called Date, we'll click the check box and click OK. All right. So, there's our object. We can move it around, we can size it.
There is a Scroll bar, so we can see the contents. In this case, we're looking at the default, which is the various months of 2012, but we know our table only has sales showing for July. If we go to July, we're not going to see any changes over here in our table because all of these dates fall in that month. However, we can go to the dropdown to choose a different filter. We have Years, Quarters, we also have Months, which is already checked off, but the one we want is Days. So, when we click Days, now we're looking at different object.
As we scroll across, we're looking at each of the individual days in July, and they are all highlighted right now. That's why we're seeing all of the data over there on the left-hand side. Let's just stretch this out so we can see at least most of the days in July as we scroll left to right. Now, we can pick an individual day if we wanted to. For example, how did we do on the first? Well, we just click the one and that's all we're going to see, sales for the first including the Grand Total. What about the first ten days? We can click and drag from one all the way across to 10 and release.
There is our total sales for the first ten days in July. Wondering about the second half? Well, again you could click and drag over the dates. Let's go from the 15th all the way to the 30th and release. So, it's a great way to quickly review data based on a timeline. In this case, viewing it by Days, but we also have the ability to view by Months, Quarters and Years. It's a handy little feature, and it is an object that we can move around and size to our liking. It's just a great way to save some time when you're trying to analyze complicated or extensive data.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70716 Viewers
80 Video lessons · 127730 Viewers
52 Video lessons · 62588 Viewers
59 Video lessons · 48307 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.