-
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:
-
how to get taxschedule from item using SQL/workbook
Hi, Is it possible to retrieve taxschedule field from item via SQL/workbook? I found following table = Tax Schedule ("taxSchedule"), but it is empty, thanks
-
Meta-calculation in Analytics Workbooks
Hi all, I'm trying to reflect an existing report we used to have coming from Business Objects in SuiteAnalytics, and I can't find a way to get rows as a proportion of the field, like so (this is wrong, obviously): Is there a way to create a calculated measure that uses the grand total? At the moment I can only get a sum of…
-
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…
-
Stop Rounding Qty in Workbook
We have a workbook which we use to find the available qty of various items and then use as an import for Inventory Adjustments. However, the values are rounding to two decimal places and we need the full number. For example 24.598 becomes 24.6 when we really need the 24.598. Is there a setting or something I can adjust to…
-
How to choose a custom relative date in a workbook?
Hi, I was wondering if you could choose a custom relative date criteria in a workbook. I know you can do this in a saved search. I was wondering if there was an equivalent functionality in a workbook. I couldn't find it. I wanted to ask to see if I was missing something or if it is just not possible. Here is a screen shot…
-
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…
-
NSC | How to create a workbook to show the latest Vendor Bill date for a Purchase Order?
SCENARIO User wants to create a Workbook for their Purchase Orders (POs) and they wants to identify the latest Vendor Bill date for each PO as it may contain multiple Vendor Bills. For example a Purchase Order dated April 1, 2024 may have the following Vendor Bills associated to it: Vendor Bill #1 | Date: April 26, 2024…
-
Suite Analytics Workbook: Inbound Shipments
Hi, I am starting with a purchase order. I am trying to get the related record of the inbound shipment so I can grab the expected ship date. I was verifying my results and I had noticed that there is an inbound shipment related to a purchase order in NetSuite but in the workbook there is no data showing that. Any idea why…
-
Suite Analytics Percent of Total
Hi, I am working in a Suite Analytics Workbook in a pivot table. I thought this would be easy but I was wrong. I am just trying to get a percent of the total or a piece of the pie. So in the screenshot below I would like to turn that count per customer into a percent of the total. So for Walmart at the top would just be…