Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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.
Tagged:
0