Search Contextures Sites

Excel Pivot Table Sorting

Amazon.com      Amazon.com	New Pivot Table Items Out of Order   Sort a Pivot Table for Top 10 Items   Pivot Table Tutorials and Videos
	New Pivot Table Items Out of Order  When you add new records to your pivot table source data, and refresh the pivot table, new items might appear in the drop down lists. Sometimes, those new items appear at the end of the list, instead of in alphabetical order. For example, in the screen shot below, binders were just added to this pivot table’s source data. When the pivot table was refreshed, Binders appeared at the bottom of the Product list, instead of the top.
	Fix the Sort Order Items in the pivot table drop down lists can get out of order, if you have manually rearranged the items in the Row Labels area. If a field is set for Manual sort, new items will appear at the end of the drop-down list. Follow these steps to sort the field in ascending order: Right-click a cell in the Product field. For example, right-click the Envelopes cell. Click Sort, and then click Sort A to Z. When you sort the Product field, its sort setting changes from Manual to Sort Ascending or Sort Descending. This also sorts the drop-down list, and makes it easier for users to find the items they need.
	Sort a Pivot Table Field Left to Right
	Usually you sort a pivot table by the values in a column, such as the Grand Total column. By sorting, you can highlight the highest or lowest values, by moving them to the top of the pivot table. To sort a pivot table column: Right-click on a value cell, and click Sort. Then, click Sort Smallest to Largest or Sort Largest to Smallest
	Sort a Pivot Table Row You can also sort a pivot table row by its values, left to right. This moves the largest or smallest amounts to the left of the pivot table, so you can focus on them. For example, in the pivot table shown below, the cities columns are in alphabetical order, with Boston at the left. To hightlight the city with the highest sales, you can sort the Chocolate Chip row, so the sales per city are sorted in descending order. To sort the pivot table row: In the pivot table, right-click a value cell in the Chocolate Chip row. Click Sort, and then click More Sort Options In the Sort By Value dialog box, under Sort Options, select Largest to Smallest. Under Sort direction, select Left to Right. In the Summary section, you can see a description of the sort settings. Click OK to close the dialog box. After you sort the Chocolate Chip row, left to right, the values in the Chocolate Chip row are sorted largest to smallest, from left to right. The City column order has changed, and Chicago, which has the highest Chocolate Chip sales, is at the left. NOTE: Rows for other products may not be in descending order, because the column order has been set by the values in the Chocolate Chip row.

Pivot Table Tutorials Excel Pivot Table -- Introduction  Excel Pivot Table -- Clear Old Items Excel Pivot Table -- Create a Pivot Table in Excel 2007  Excel Pivot Table -- Custom Calculations  Excel Pivot Table -- Data Field Layout Excel Pivot Table -- Dynamic Data Source Excel Pivot Table -- FAQs Excel Pivot Table -- Field Settings Excel Pivot Table -- Filter Source Data   Excel Pivot Table -- Filters, Top 10  Excel Pivot Table -- GetPivotData Excel Pivot Table -- Grand Totals Excel Pivot Table -- Grouping Data Excel Pivot Table -- Layout, Excel 2007 Excel Pivot Table -- Multiple Consolidation Ranges Excel Pivot Table -- Pivot Cache    Excel Pivot Table -- PivotTable Style Excel Pivot Table -- Printing    Excel Pivot Table -- Protection   Excel Pivot Table -- Report Filters Excel Pivot Table -- Running Totals   Excel Pivot Table -- Show and Hide Items  Excel Pivot Table -- Sorting Excel Pivot Table -- Subtotals  Excel Pivot Table -- Summary Functions Excel Pivot Table -- Unique Items

Pivot Table Books Pivot Tables, Beginning (Excel 2007)  Pivot Tables, Recipe Book (Excel 2003)  Pivot Tables, Recipe Book (Excel 2007)  Pivot Table Add-Ins Pivot Tables - Add-in -- Pivot Power  Pivot Tables - Add-in - Pivot Play PLUS  Pivot Table Videos Pivot Tables - Clear Old Items Pivot Tables - Copy a Custom PivotTable Style Pivot Tables - Create in Excel 2007 Pivot Tables - Create from Multiple Sheets Pivot Tables - Data Field Layout Pivot Tables - Date Filters, Add Pivot Tables - GetPivotData Pivot Tables - Group Data Pivot Tables - Layout, Excel 2007 Pivot Tables - Report Filters, Add Pivot Tables - Running Totals Pivot Tables - Select Sections Pivot Tables - Subtotals, Create Multiple Pivot Tables - Top 10 Filters

 

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2010 All rights reserved.	Debra Dalgleish

Last updated: July 3, 2010