Skip to Content
avatar image
Former Member

Pass Crosstab Measure Selection(s) to Second Crosstab

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?
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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(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.

    Add comment
    10|10000 characters needed characters exceeded