Modules
Objects/Functions
SuiteScript 2.0
{workbook}.createConditionalFilter({filteredNodesSelector: {workbook.AllSubNodesSelector |workbook.DimensionSelector | workbook.PathSelector*},measure: {workbook.Measure*},otherAxisSelector: {workbook.AllSubNodesSelector |workbook.DimensionSelector | workbook.PathSelector*},predicate: {workbook.Expression*},row: {boolean*}})
N/workbook Module
workbook.createConditionalFilter()
Method Description:
Creates a conditional filter, which includes a selector of what to filter, a row axis and other axis, a measure and a predicate. Conditional filters can be used in pivot definitions and chart definitions.
Returns:
workbook.ConditionalFilter
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.createConditionalFilter(options)
Example:
// Code Example 1
// Add additional code
//...
// Create a ConditionalFilter
var myConditionalFilter = workbook.createConditionalFilter({
row: true,
otherAxisSelector: myDimensionSelector,
filteredNodesSelector: myPathSelector,
measure: myMeasure,
predicate: myExpression
});
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159050988221.html