cancel
Showing results for 
Search instead for 
Did you mean: 

Pass Crosstab Measure Selection(s) to Second Crosstab

former_member559323
Discoverer
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

MustafaBensan
Active Contributor
0 Kudos

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(measuresDimension.name);
 
 var selectedDimensionMembers = me.getSelectedMembers(<Evnt Org Level 2 Technical ID>);

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

Regards,

Mustafa.