To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

Further, be aware that as a default, Excel’s PivotTable sort function sorts by custom lists, which explains why a PivotTable will sort months (January, February, March, etc.) in month order instead of ...