Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Using Formulas in Suiteanalytics datasets abd workbooks
Hi Everybody
I am trying to build a dataset containing.
Account Type
Year
Month
Month Total
From here, I want a pivot table with Columns
- Account
Mth to Date
Ytd Total ( formula Mth to Date (sum)
I need to be able to filter by current month;
I am building my way to Act vs Budget tables that have more flexibility and can be displayed on Dashboards
My SQL skills cover the basics of CASE, TO_etc, COnCat RTRIM and LTRIM - but if pointed in the right direction I can usually work it out but it is time-consuming.
Cheers Ross
Ross Leahy
NetSuite Enablement