Japanese garden aka Pu La Deshpande Garden

Sort the Pivot table

---

Often we have pivot table containing data that you would want to sort or take the top 10 records, we knew how to do it in autofilter. Below are the steps in order to do the same in a pivot table.

1. Create a pivot table to play with





2. Right Click on any row header and click Field settings





3. From the window that appears click advance





4. Select the auto sort options and pick the field and you are done.





5. Click ok on all the windows to see the result