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 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Creating a custom sort order

Most of the time, when you sort Pivot Table data, you can use the standard methods to sort the values in alphabetical or numerical order. There will be times though when you want to define a custom list of values and sort a Pivot Table 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 within a Pivot Table instead of an alphabetical order, you can create a custom list and use that list to sort your field's values. As an example, here is the Pivot Table that contains sales broken up by region: North, East, West and South, except that the regions are sorted into alphabetical order starting with East and going on through West.

If you want to create a custom list of values and sort using those values, first you go to Excel>Preferences and in the Excel Preferences dialog box, click Custom lists. You can use the Custom lists page of the Excel Preferences dialog box to create your new cu...

Creating a custom sort order
Video duration: 2m 54s 1h 7m Intermediate

Viewers:

Creating a custom sort order provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

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