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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
New to NetSuite | Pivot Table of Budget Workbook is showing Period Name in wrong order
SuiteAnalytics Workbook is a versatile analytical tool that enables users to create customized workbooks. It seamlessly combines datasets, tables, pivot tables, and charts into a single platform. Due to the customization options available in workbooks, it's possible to encounter unexpected behavior when sorting certain fields, such as the Periods field.
Scenario:
User is having trouble sorting the workbook data by Period and the results are not as expected.
Actual Results:
After sorting option:
Expected Results:
Solution:
Make sure to select the appropriate field in your Dataset Workbook with the correct icon. For the Periods fields, it is recommended to select the fields with the “
Katerina Winklerova
Basic Accounting/ OTC/PTP Guru
0