Skip to Content

Pass Crosstab Measure Selection(s) to Second Crosstab

Feb 24 at 05:35 PM


avatar image

I have a summary crosstab showing multiple types of counts for a given dimension. The user wants to be able to select any of these counts and see the underlying detail. How do I identify the dimension member and measure name of the count selected?
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mustafa Bensan Feb 25 at 01:53 AM

Hi Meredith,

In the "On Select" event script of your Crosstab you can apply code similar to this, where DS_1 is the data source assigned to your Crosstab:

 var measuresDimension = DS_1.getMeasuresDimension();
 var selectedMeasures = me.getSelectedMembers(;
 var selectedDimensionMembers = me.getSelectedMembers(<Evnt Org Level 2 Technical ID>);

You can then use selectedMeasures and selectedDimensionMembers to drive the detail Crosstab.



10 |10000 characters needed characters left characters exceeded