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.

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.