-
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
-
Analytics: Add Percentage Column to Pivot Table
I would like to add a column, next to the document count, that would show the percentage of the total for each count. How do you do this in Analytics pivot table? Also, is there a way to get my "Bin" column to custom sort (not alpha-numeric), but in a way that would be logical for this data set?
-
SuiteAnalytics Calculations
I have a pivot table with two columns Item Quantity I am sort based on quantity What I really want is a % of the Total column (like old fashion reports can do) Any suggestions?
-
calculate formula for multiple fields in custom record
Hello I want to calculate multiple fields in a custom record ( like ( A*B*C) / 5000 ) So how I can do this? This is what I wrote but not work Thank you for advice
-
Suiteanalytics summarize calculated measure with a max value being used
I have a calculated measure on my SA workbook. consists of both a max value and a sum value, but on the grand total it just shows the max of that field. I want that to show the summary though. In general, the use case for this is I have forecast records that I'm wanting to access from a sales order SA pivot table and want…
-
calculated measure in saved search
Hi, I have a saved search month wise which gives me Branch (summary type - group by) Customer (summary type - count) Activities (summary type - count) Branch Customer Activities A 100 456 B 150 675 My objective is to get customer coverage by branch for a month which needs count of activities / count of distinct customers.…