Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

CHAPTER 4Sorting and Filtering the Pivot Table

You now have a pivot table that is starting to display the results you are looking to achieve from your data. You have learned the skills to create the pivot table, to make the pivot table look better, and to add and change calculations. Now, you want the pivot table to display the data in a certain order, or you might want the pivot table to display only a subset of the data. In this chapter, you will learn many ways to sort the pivot table in the order you want, and you will also learn to filter the pivot table so it displays the exact results you are looking for.

NOTE  For the examples presented in this section of the chapter, you can use the sample file called Sorts and Filters.xlsx that is included with this book. You can find the sample files at www.wiley.com/go/GGRXL_PivotTables. Each section of this chapter will indicate which sheet to use from this workbook.

Sorting the Pivot Table

The information in the pivot table can be sorted to arrange the data in the order that you want it displayed. You can sort by any column in the pivot table, by any row in the pivot table, or by the rows and columns at the same time. The sort can be in alphabetical order or reverse alphabetical order for words, it can be in ascending or descending order for numbers and dates, or you can create your own order. The rows and columns ...