PivotAxis.sortDefinitions

Property Description

The sort definitions of the pivot axis.

Type

workbook.SortDefinition[]

Module

N/workbook Module

Parent Object

workbook.PivotAxis

Sibling Object Members

PivotAxis Object Members

Since

2020.2

Errors

Error Code

Thrown If

WRONG_PARAMETER_TYPE

The value specified for this property is not a workbook.SortDefinition[].

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/workbook Module Script Samples. Also see Full scripts in the Tutorial: Creating a Workbook Using the Workbook API topic.

            // Add additional code
...
// View PivotAxis.sortDefinitions in a PivotDefinition
var myWorkbook = workbook.load({
    id: myWorkbookId 
});

log.audit({
    title: 'PivotDefinition PivotAxis(rowAxis) sortDefinitions = ',
    details: myWorkbook.pivotDefinitions[0].rowAxis.sortDefinitions
});

log.audit({
    title: 'PivotDefinition PivotAxis (columnAxis) sortDefinitions = ',
    details: myWorkbook.pivotDefinitions[0].columnAxis.sortDefinitions
});
...
// Add additional code 

          

Related Topics

General Notices