Skip to Content

Crosstab filter while drilling the data

Feb 08, 2017 at 02:41 PM


avatar image

Dear Experts,

I am trying to apply to a filter on crosstab data. My first column is a customer and I have also enabled the drill on customer.

The drill path flows as follow: Customer> Region>Country

There is also a chart in the dashboard with data source DS_2 which is showing the values for Year wise Volume, Revenue and margin data in 3 different bar charts

When I use the following code: DS_CHART.setFilter("Customer", CROSSTAB_1.getSelectedMember("Customer")); and disable the drill it works fine and I am able to filter the data of the chart based on row selection in crosstab. But when I enable the drill for Customer, the filter stops working. This is the code for the Customer drill in crosstab.

DS_CROSSTAB.swapDimensions("Customer", "Region");

DS_CROSSTAB.swapDimensions("Customer", "Country");

Kindly advise.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Feb 08, 2017 at 04:40 PM

Hi Sumit,

Please try the following script. It should work you you

Step1: Create a global script variable

Step 2: Crosstab Script

if (level==true)


var b = CROSSTAB_1.getSelectedMember("Customer");

DS_2.setFilter("Customer", b);

DS_CROSSTAB.setFilter("Customer", b);




if (level==false)


var a = CROSSTAB_1.getSelectedMember("Region");

DS_2.setFilter("Region", a);

DS_CROSSTAB.setFilter("Region", a);



level= true;


global-script.png (10.3 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Bhupinder

Let me try this.