Sorting data in pivot table

In this article you will learn how to sort data in a pivot table. You may need this for better visual eg. top buyers.

1. Create a pivot table.

sorting data

2. Click the arrow on Row Labels or Column Labels, and then click the sort option you want.

3. To sort data in ascending or descending order, click Sort A to Z or Sort Z to A.

sort a to z

4. To find additional sorting options, click on more sort options.

additional sorting options

Note: Manual sort option allows manual sorting through dragging. Items can be rearranged by dragging them (values cannot be dragged)

5. Ascending (A to Z) by and Decending (Z to A) helps you in sorting according to alphabetical order and according to sum of quantity.

ascending a to z

6. In more options you can tick sort automatically every time the report is updated. It will automatically sort the data when your pivot table is updated.

sort automatically