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!
NSAW - Calcs between cols
Hi Gurus,
I’m working on building a simple demand forecast based on average sales over the past 12 weeks.
I need a column that simply displays sequential numbers like 1, 2, 3, ... for each row in my pivot — regardless of any grouping or the number of items.
I first tried using RCOUNT(1)
to generate the sequence, but in the pivot table, it's calculating based on the number of items included in the Rows. For example, if 3 items are present in each row, it returns values like 3, 6, 9, instead of 1, 2, 3.
Then I attempted to extract the month and day from a date field (WeekStart
) to new col (data calc), and applied