Filter excluding specific values (all values are returned except those specified)

In this example we filter the table to show all ‘Sales Managers’ except the 2 specified. You will need to know the member ID’s of the dimension members.

In this example SM1 & SM2 are the Sales Managers – Janet Bury & Lois Wood

This KB shows you how to log the dimension members to the browser console

Table_1.getDataSource().setDimensionFilter(“Sales_Manager”,{values: [“SM1″,”SM2”],exclude:true});

Table_1.getDataSource().setDimensionFilter("Sales_Manager",{values: ["SM1","SM2"],exclude:true});
Code language: JavaScript (javascript)

bACK