-
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:
-
Convert AR Aging Report to Analytics Workbook
Hello, I need help converting an AR aging report to an analytics workbook. Not sure if this is even possible. I can send the report link directly to whoever works on this request. Please let me know if anything else is needed. Thanks!
-
Analytic Workbook Calculated Measure Definition
I am trying to create 3 calculated measures in my workbook to show the sum of sales by location Current Week to Date, Last Week to Date and Same Week Last Year My Data set contains the data for the 3 periods but I have not been able to get the definition to work. Any help would be appreciated Thanks
-
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…
-
Customer needs help with a formula in transaction dataset.
Need helping with MOD function where N1 and N2 are CASE WHEN ({transactionlines.transactionlinetype#display} = "Inventory Count : Count Quantity" THEN {quantity} ELSE END, {transactionlines.transactionlinetype#display} = "Inventory Count : Adjusted Quantity" THEN {quantity} ELSE END) Dataset is Transaction. Associated…
-
How to schedule Analytics Workbook for automatic delivery to users?
Hi Could you please let me know, how to schedule analytics workbook for scheduled automatic delivery to users
-
How to Connect Datasets in Workbook when it's block
Hi All, I'm trying to connect to datasets that built, one is the approval Matrix and the second is of the employee. I want to create joins between the employee internal id and the approver id (picture attached), but the Analytics blocks me to do it . Can you advise? thank you,
-
Schedule a workbook
Hi, is it possible to schedule a workbook to be delivered daily to certain recipients, much like you can for a report? many thanks Andy
-
Analytics with click option
Hi all How do we setup the analytic workbook so the results would allow us to drill in to it or open the transaction record by clicking it. Currently I only see salesrep , employee values that are clickable but not the transaction. This is on pivot tables . Is this the behaviour or is there any workaround to achieve this?…