Modules
Objects/Functions
SuiteScript 2.0
{workbook}.createMeasureSort({measure: {workbook.Measure*},otherAxisSelector: {workbook.AllSubNodesSelector |workbook.DimensionSelector | workbook.PathSelector*},selector: {workbook.AllSubNodesSelector |workbook.DimensionSelector | workbook.PathSelector*},sort: {workbook.Sort*}})
N/workbook Module
workbook.createMeasureSort()
Method Description:
Creates a measure sort, which defines a sort on a measure.
Returns:
workbook.MeasureSort
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.createMeasureSort(options)
Example:
// Code Example 1
// Add additional code
//...
// Create a DimensionSelector-DimensionSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myDimensionSelector,
otherAxisSelector: myOtherDimensionSelector,
sort: mySort
});
// Create a PathSelector-PathSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myPathSelector,
otherAxisSelector: myOtherPathSelector,
sort: mySort
});
// Create a DimensionSelector-PathSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myDimensionSelector,
otherAxisSelector: myPathSelector,
sort: mySort
});
// Create a PathSelector-DimensionSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myPathSelector,
otherAxisSelector: myDimensionSelector,
sort: mySort
});
// Create a DimensionSelector-AllSubNodesSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myDimensionSelector,
otherAxisSelector: myAllSubNodesSelector,
sort: mySort
});
// Create a AllSubNodeSelector-DimensionSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myAllSubNodesSelector,
otherAxisSelector: myDimensionSelector,
sort: mySort
});
// Create a AllSubNodeSelector-PathSelector MeasureSort
var myMeasureSort = workbook.createMeasureSort({
measure: myMeasure,
selector: myAllSubNodesSelector,
otherAxisSelector: myPathSelector,
sort: mySort
});
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159051560022.html