-
Analytics Workbook - Pivot Table - No hyperlink available to click for Document Number/ID
I have a workbook that is linked to a quote dataset and I have both Transaction and Document Number/ID added to the dataset. In the dataset, they are perfectly hyperlinked so the user can click it and be taken to the quote record as needed. When in the workbook, the hyperlink on both works just as needed in the table view,…
-
NSAW using calculation/key metric formulas in pivot table
Hi, I am trying to create an easy way to see the average item sales rate. I want to take the total dollars sold / total quantity sold so I can get this average rate. I created a calculation with the following formula. SUM(Item rate * shipped quantity) / SUM(shipped quantity) When I add this into the pivot table, I assume…
-
Why is NSAW Pivot Table is inflating the results
Hi, I am trying to create a simple pivot table in NSAW. I am using sales order data. I am trying to calculate the average sale rate for each item by taking the total sales number / # of units shipped. For some reason, the pivot table is inflating the values and I do not know why. I have a separate canvas for a data table…
-
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…
-
SuiteAnalytics: Create a Running Total
Hi Team, Using SuiteAnalytics Workbooks, on a Pivot, is there a way to add a column that is a running total based on one of the measures? Thank you
-
Can we link 3 dataset in workbook?
Hi all, I wonder that could we link 3 dataset in workbook? Since I tried to link 3 dataset in a workbook. It likely worked. But then, I did a pivot for those dataset, it just only shown 2 dataset. The third 3rd was disapeared. So, I wonder that workbook has a limit for a number of linking dataset? Thank you. Mei.
-
How to Export Export Workbook Analytical Pivot Report as PDF
Hello Commiunity Is it possible to export analytical workbook report to excel or pdf ?
-
How to change the order of the columns in a Pivot Table of Budget Workbook?
Hi Guru's, Is there a way to change the order of the columns in a Pivot Table (analytics). I just created a budget workbook with the Period Name (months) but the order of these columns doesn't make any sense. Anyone have an idea how I can solve this? Thanks in Advanced. Regards, Toanne
-
NSC | Report for Items Shipped by Month
Scenario User needs a report of the items shipped on a monthly basis. The report needs to have the months as columns for easier visualization and data analysis. Currently, pulling the data on a per month basis in a Report is not possible yet. We do have an enhancement related to this: Enhancement # 138533 - Reports >…
-
NSC | Add Long Text and Rich Text fields to Pivots in SuiteAnalytics Workbook
Scenario Currently, it is not possible to add Long Text and Rich Text type fields to Pivots in SuiteAnalytics Workbook. This is parallel to the behavior in Saved Searches that Long Text and Rich Text have the Summary Type grayed out. The standard behavior is that Character Large Object (CLOB) type fields can't be grouped.…