New to SuiteAnalytics and still watching videos bu...
# suiteanalytics
n
New to SuiteAnalytics and still watching videos but two big questions I have at the moment. 1. I am showing data in a pivot table over 12 months. (months being columns) is there a way to change headers from 1,2,3,4,etc to Jan, Feb, March, April, etc. ? 2. In a pivot table, personal preference is that null values show as '0', is that possible? Not looking for the "how" but if it is possible, just tell me so I dont feel like I am chasing a red herring.
r
I have not found this. But if you really need for a particular report you can add a custom filed to the dataset to transform the field to zero when null (NVL, NVL2, NAVL). I had to do this for an integration. Also you can format a new field for Month_Name but you will have to label as 1- Jan so that your sort ascending still works. These are just hacks until NS allows more customization or someone else knows how.