While you are dragging East, a horizontal green bar appears across the entire row moves. Under Summary, the current sort order is given as Drag items of the Region field to display them in any order.Ĭlick on the East and drag it to the top.
SORT EXCEL FOR MAC TABLE ALPHABETICALLY MANUAL
Select Manual (you can drag items to rearrange them). Select Region in the Select Field box from the dropdown list.Ĭlick More Sort Options. Now, suppose you want to sort the field Region in the order – East, West, North and South. Place the cursor on the arrow in Row Labels or Column Labels.ĪutoSort appears, showing the current sort order for each of the fields in the PivotTable. In the PivotTable, the data is sorted automatically by the sorting option that you have chosen. The PivotTable will be sorted on region, using values in January.Īs you can observe, in the month of January, West has the highest order amount while North has the lowest. Sort Region by Sum of Order Amount in descending order, using values in this column: January. Under Summary, the current sort order is given as follows − Select Descending (Z to A) by: under Sort Options. Sort Region by Sum of Order Amount in ascending order using values in this column: January. Under Summary, the current sort order is given as Sort Region by Sum of Order Amount in ascending order.Ĭlick Values in selected column: under Sort By.Īs you can observe, under Summary, the current sort order is given as follows − The More Sort Options (Region) dialog box appears.Īs you can observe, under Sort By, Grand Total is selected. In the box below that, Region is displayed.Ĭlick the More Options button.
Ascending (A to Z) by is selected under Sort Options. The Sort (Region) dialog box appears.Īs you can observe, under Summary, the current Sort order is given as Sort Region in ascending order. Select More Sort Options from the dropdown list. Suppose you want to sort the PivotTable on total amount region wise in the month of January. You can observe that February has highest order amount while March has the lowest. The PivotTable will be sorted on total amount month wise.
Select Sort Largest to Smallest from the second dropdown list.Right click on any of the Subtotals in the Grand Total row.You can also sort the PivotTable based on the total amount month wise as follows − The PivotTable will get sorted on subtotals region-wise.Īs you can observe, South has the highest order amount while North has the lowest. Right click on the subtotal of any of the regions in the Grand Total column.Ĭlick Sort Largest to Smallest in the second dropdown list. Likewise, if you want to sort the PivotTable on subtotals region wise, do the following − The subtotals in the Grand Total column are sorted from highest to lowest values, in every region. Right-click on the subtotal of any of the Salespersons in the Grand Total column.Īnother dropdown list appears with the sorting options – Sort Smallest to Largest, Sort Largest to Smallest and More Sort Options. You can still sort the PivotTable on subtotals as follows − You can see that there is no arrow for subtotals. That is, you want to sort the PivotTable on subtotals.
Suppose you want to sort the PivotTable based on total order amount – highest to lowest in every Region.
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 kommentar(er)
