Tuesday, May 8, 2012

How to Sort Data in Excel Pivot Table

I presume you already know how to create pivot table in Excel (Data>Pivot Table and Pivot Chart Report). So this posting is only to show you how to sort the data displayed in the pivot table, automatically. In other words, you don't have to sort them each time you refresh the pivot table.
This is how to do it. First, you right click the column header that you want to sort (on the left side of the table). Then click 'Field Settings'. Click 'Advanced'. Do you see 'AutoSort options' there? Yes, correct ... that's the place you can play around with. You can select 'Ascending' or 'Descending', depend on what you need. You can even select 'Top 10 AutoShow' there so that Excel will show you only the top 10!