Discussions
Tips & Tricks: How to Sort Multiple Columns in a Workbook Pivot Table
Sorting probably isn’t the fanciest topic to boast about. Usually, it’s very simple, intuitive, and everybody already knows how it works. However, there is one little trick with Workbook pivots that helps you find the right data quickly.
This feature is called “Groups” and chances are, some of you may have not even noticed it’s there. But before I jump into “how,” let’s demonstrate “what” it does.
Some of the pivots you may build contain multiple fields in rows and columns. Workbook automatically creates a standard group structure for the data where the leading/root element is the first field you added into the pivot’s rows or columns.