PivotAxis.root
Property Description |
The root data for the pivot axis. |
Type |
|
Module |
|
Parent Object |
|
Sibling Object Members |
|
Since |
2020.2 |
Errors
Error Code |
Thrown If |
---|---|
|
The value specified for this property is not a workbook.DataDimension or a workbook.Section. |
Syntax
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.root in a PivotDefinition
var myWorkbook = workbook.load({
id: myWorkbookId
});
log.audit({
title: 'PivotDefinition PivotAxis(rowAxis) root = ',
details: myWorkbook.pivotDefinitions[0].rowAxis.root
});
log.audit({
title: 'PivotDefinition PivotAxis (columnAxis) root = ',
details: myWorkbook.pivotDefinitions[0].columnAxis.root
});
...
// Add additional code