N/workbook Module
workbook.PivotAxis
Object Description: A pivot axis. A pivot axis is used with you create a pivot definition. You can create a pivot axis using workbook.createPivotAxis(options).
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Module: N/workbook Module
Methods and Properties: PivotAxis Object Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.PivotAxis

// 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]

});



// View a workbook.PivotAxis used in a PivotDefinition

var myWorkbook = workbook.load ({

    id: myWorkbookId

});



var myPivotAxis = pivotDefinitions[0].rowAxis.root;



// Note that some PivotAxis properties may be empty/null based on the loaded workbook

log.audit({

    title: 'PivotAxis root = ',

    details: myPivotAxis.root

});

log.audit({

    title: 'PivotAxis sortDefinitions = ',

    details: myPivotAxis.sortDefinitions

});

//...

// Add additional code



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