Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary. ... A PivotTable is a great way to discern how many t-shirts each client purchases by size.

Click "Add" for the Rows, Columns, Values, and Filter to build your pivot table. Sophie Putka/Insider Modify how data is presented in row categories by changing the Order or Sort by setting.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, ... right-click any unit price cell, choose Sort, and then choose Sort Largest to Smallest.

When you click on a text-based column in a PivotTable and select Sort from the Data tab, the resulting dialog box (pictured at the top of the next column) provides additional sort options for sorting ...