Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.createPivotAxis(options)

{workbook}.createPivotAxis({root: {workbook.DataDimension | workbook.Section*},sortDefinitions: {workbook.SortDefinition[]}})

N/workbook Module
workbook.createPivotAxis()
Method Description: Creates a pivot axis, which includes a data root and a sort definition.
Returns: workbook.PivotAxis
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: None
Module: N/workbook Module
Sibling Module Members: N/workbook Module Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.createPivotAxis(options)

Example:

// Code Example 1
// Add additional code
//...
// Create a basic Section-based PivotAxis
var myPivotAxis = workbook.createPivotAxis({
root: mySection
});

// Create a basic DataDimension-based PivotAxis
var myPivotAxis = workbook.createPivotAxis({
root: myDataDimension
});

// Create a sorted Section-based PivotAxis
var myPivotAxis = workbook.createPivotAxis({
root: mySection,
sortDefinitions: [mySortDefinition]
});

// Create a sorted DataDimension-based PivotAxis
var myPivotAxis = workbook.createPivotAxis({
root: myDataDimension,
sortDefinitions: [mySortDefinition]
});
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159051729422.html