The business have now requested a slightly different report. They'd like to see quarterly sales trends by region for 2015 and 2016. What we want to be able to do is actually focus on a subset of the data. And Pivots will allow us to do this using the Group, Sort, and Filter tools. Let's see how they work. Now, to begin with, having a look at the report we created last time, it's showing a breakdown by year which is not going to be adequate. So we're going to come over to our Field list, unselect here, and instead, we're going to grab Order Date and drag it and drop it into the Columns region. Now, something interesting has happened. Rather than showing me each individual date as I would expect, it has automatically grouped those dates by year. Now, if you have a slightly older version, this might not have occurred, and it's possible that you don't actually want this grouping. So the first thing we'll look at is how we can ungroup the data. So I'm going to click onto one of the year fields in my pivot, come up to my Analyze tab, and in the Group Section, you'll see Ungroup. I'm going to click on that. And now I'm seeing each individual date from my original dataset. Now, that's actually no good to me at all. I definitely will need to group these dates or I'm not going to get anything useful. But we want group by quarter and year. So making sure you've clicked on one of the dates, come up your Analyze tab, click Group Field. And we don't want to group by Months, so I'm going to unselect that, and I'm going to choose Quarters and Years, and then click OK. And now I can see my data showing by quarter and year. So the Group Field works very well with both dates and numeric amounts if you need to group them. Once you've grouped data, you can also choose to collapse or expand the group. So for example, if I click on one of my dates, come up to my Group Field, just to the left of it, you'll see Collapse, which then collapses the field, and Expand, which expands to show the detail. I'm going to collapse it again. You can also expand just one of the values. So for example, to see my detail for 2015, I click on the plus, and again to collapse it, I click on the minus. So grouping data allows us to work with dates much more easily in a Pivot. You will notice that Pivot Tables automatically sort the data by Row and Column Label, which often is enough. But if you want to change the sort order, you can. And I would actually like to see total sales from smallest to largest by region. So I'm going to click into my Grand Total column because that's what I want to sort, come up to my Data tab and simply choose Sort Smallest to Largest. So you can sort data into Pivot just like it sort data anywhere else. I do need to make one more change though. I said I wanted to see the sales just for 2015 and 2016. So I now also want to filter this data. And you can filter by Column or Row Label. If I come to my Column Labels and come across to Date Filters, you will see I get all the rich Filter options I would have when I normally filter the data. I don't need to do any of those though, so I'm just going to come down to Select All, uncheck, and I'm going to choose 2015 and 2016, and say OK. And there's my summary. Let's say, for example, I only want to see sales for Western Australia and Victoria. If I click my little Auto Filter button, I can unselect New South Wales, say OK, and now it's filtering the data both by Column and Row Label. To clear a filter, you can clear all of them by clicking somewhere in your Pivot Table, coming up here to Data tab and saying Clear, or you also have a Clear Filter on the Pivot Table tool's Analyze behind the Clear button. I don't want to clear all the filters though. I just want to clear the one from my Row Label. So what I'm going to do, I'm just going to make this a bit wider so you can see what happens. I'm going to click my Auto Filter button and choose Clear Filter From "State." And that has just cleared that filter. Let's make one more little modification. I'm going to click back onto my year and expand my group, and then my quarterly sales for 2015 and 2016 by region sorted from smallest to largest. So we've now seen how you can focus on subsets of the data by using your Group, Sort, and Filter tools.