In the same way, you can sort the field in column – Month, by clicking on the arrow in the column labels. The Salesperson field will be sorted in descending order. The following sorting options are displayed −įurther, the Salesperson field is sorted in ascending order, by default. Select Salesperson in the Select Field box from the dropdown list. To sort the PivotTable with the field Salesperson, proceed as follows − You can sort the data in the above PivotTable on Fields that are in Rows or Columns – Region, Salesperson and Month. You can sort the data from lowest to highest values or highest to lowest values or in any other custom order that you choose.Ĭonsider the following PivotTable wherein you have the summarized sales data region-wise, salesperson-wise and month-wise. You can sort the data in a PivotTable so that it will be easy for you to find the items you want to analyze.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |