Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Now, you can stay up-to-date with the latest discussions, helpful tips, and important announcements, all delivered straight to your inbox. Whether you’re looking to catch up on what you missed or just want a quick overview, our email digest has you covered. To learn more and to subscribe, click here.
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.