Apply a filter using resultset values

The script is placed in the button, when clicked it passes the values from Table_1 & applies them as a filter to Table_2

var dims = Table_1.getDimensionsOnRows()[0];  
// dynamically get the dimension on the first row of the source table
var selections=Table_1.getDataSource().getDataSelections();
var members = ArrayUtils.create(Type.string);
for (var i = 0; i < selections.length; i++) {var member = Table_1.getDataSource().getResultMember(dims, selections[i]);
{  members.push(member.id);}}
Table_2.getDataSource().setDimensionFilter("Sales_Manager__5w3m5d06b5",members);

var dims = Table_1.getDimensionsOnRows()[0];  
// dynamically get the dimension on the first row of the source table
var selections=Table_1.getDataSource().getDataSelections();
var members = ArrayUtils.create(Type.string);
for (var i = 0; i < selections.length; i++) {var member = Table_1.getDataSource().getResultMember(dims, selections[i]);
{  members.push(member.id);}}
Table_2.getDataSource().setDimensionFilter("Sales_Manager__5w3m5d06b5",members);
Code language: JavaScript (javascript)

bACK