Creating a custom sort order


show more Creating a custom sort order provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Creating a custom sort order

Most of the time when you sort PivotTable data you can use the standard methods to sort the values in alphabetical or numeric order. There will be times though when you might want to define a custom list of values and sort a PivotTable using those values. For example, if your company has stores in four regions, north, south, east, and west, and you want the regions to show in that order, instead of alphabetical order, you can create a custom list and use that list to sort your fields' values. So for this example, I have a PivotTable with sales data for four regions, east north, south, and west, but I want to have them sorted into the order north, south, east and west, instead of alphabetical order like they are now.

To do that we can create a custom list. So click the File tab on the Ribbon to display the Backstage view, and then click Options to display the Excel Options dialog box, and then on the Advanced page scroll down, which I'll do using my mouse with scroll wheel, an...

Creating a custom sort order
Video duration: 2m 48s 3h 43m Intermediate

Viewers:

Creating a custom sort order provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...