-
Drill Down in Analytics Workbook Pivot Table
Is it possible to drill down in a Pivot Table in an Analytics Workbook? Mine is static in NS and when exported to Excel. I was hoping it would be dynamic like a standard pivot table is in Excel so that I can drill into certain transactions. I found this existing Community Topic from 2021 but nothing since:
-
NetSuite Admin Tip | SuiteAnalytics Workbook to Identify Active Employees with Inactive Supervisor
In many organizations, the Supervisor field on the Employee record represents the reporting structure used for approvals, escalations, notifications, task ownership, and operational reporting. Over time, these reporting relationships can become outdated due to promotions, reorganizations, or employee terminations. One…
-
SuiteAnalytics Workbook error when adding formula referencing statistical accounts and consolidated
I’m building a Workbook to combine amounts from journal entries with quantities from statistical journals. Statistical accounts are aligned with corresponding GL accounts. The goal is an income statement by department that shows both expense amounts and related statistical quantities. Issue: When adding a formula to the…
-
End-to-End Manufacturing Process Tracking in NetSuite (Workbooks vs SuiteQL)
We have 4 process groups and workorders (CPI → Cutting → Stitching → Finished Goods) to produce finished goods from raw material. We need full tracking from Customer Sales Order to Group Invoice, linking Customer, Item, Transaction, and Manufacturing datasets. The challenge: some joins require self-joins / inner / outer…
-
Customer needs help with a formula to show a field IF a statement is true.
Customer has a workbook and would like to pull a string if a field on the note is set to management. This workbook is all standard and not customized. See below. Specifically looking for, if a note type is Management, then show the memo field, else show nothing. All done in an analytic workbook.
-
MAX and SUM in Dataset for workbook.
Customer needs help with the below. Need to MAX the yellow highlighted items and SUM the green. This is a formula in the dataset.
-
Analytics Workbook - trying to use "Main Line"
Hi Team, I created a report under workbook. I am trying to only show one line per transaction and have added "MAIN LINE" and set this YES. However, its still not working. Do you have any inputs here?
-
In need of a search/report/workbook that will show me sales of two items that are on the same order
I am looking to create a search, report or workbook that will show me sales of item A and item B when on the same sale. I want to see the item, qty sold and sales amounts only for those two items in the results. I have tried "item on any line" in a search but the results pull all the items on that sale and I only need the…
-
Duplicate rows in workbook
Hello My target is to merge 2 datasets in one workbook, those 2 datasets are simple and contain: Item Name/Number: is the same for both data sets Location: is same for both data sets (and it is used as a filter) Total Quantity On Hand: is the same for both data sets Unit Price (a different level of prices) filtered by USD…
-
Can you copy an Analytics Workbook to another account?
Is there no way to copy a workbook or dataset to another account or bundle it?