You can temporarily remove Customer from the pivot table, sort descending by revenue, and then add Customer back. Excel understands that you want to set up a sort rule for the Sector field. When you have only the sectors showing, select H4 and click ZA to sort descending. You can select cell G4 and then use Collapse Field on the Analyze tab to hide the customer detail. The following tricks can be used for sorting an outer row field by revenue: It might make more sense, though, to put the largest sectors at the top. If you could see the entire pivot table in G3:H35 in Figure 4-6, you would notice that the sectors are sorted alphabetically. You could remove Customer from the pivot table, do more adjustments, and then add Customer back to the column area, and Excel would remember that the customers should be presented from high to low. Within Consulting, Surten Excel appears first, with $750K, followed by NetCom, with $614K. Within each sector, the pivot table continues to sort the data in descending order by revenue. The pivot table in columns G:H shows what happens after you add Sector as a new outer row field. When you sort inside a pivot table, Excel sets up a rule that will be used after you make additional changes to the pivot table. Although that sounds like a regular sort, it is better. This pivot table was sorted by selecting cell E3 and choosing the ZA icon in the Data tab of the ribbon. In the second pivot table, the report is sorted in descending sequence by Total Revenue. Figure 4-6 When you override the default sort, Excel remembers the sort as additional fields are added.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |