If the field which has items from a custom list is set for Automatic sort, it should change to the custom list's sort order. If the field is currently set for manual sorting, it won't sort according to the custom list order.
You can sort the items in alphabetical order, either manually (as described below or with programming (get the report filter sorting macro here ). New Items at End of List In this example, the Product field is in the Report Filter area, and Binders is.
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.
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.
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.
insurance description of manual therapy />Right-click a cell in the Product field. For example, right-click the Envelopes cell. Click Sort, and then click Sort A to Z. Drag the Product field back to the Report Filter area. When you sort the Product field, its sort setting changes from Manual to.