Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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
