Skip to Content
avatar image
Former Member

Design studio crosstab drill down

Hi,

I would like to filter and drill down on a value selected in a crosstab two levels down. For example when clicking on Division - I want to drill down to Sub-Division and sub-division must replace the division column in the crosstab. Then I want to drill down another level, when clicking on Sub-division I want to drill down to Department and department must replace sub-division in the same crosstab.

Can someone please help me with code for doing this. I can get one level down, but two I can't get to work.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 08, 2016 at 11:27 AM

    Hi Erika Schoombee

    This below code can help you to change dimensions and filter selected value in crosstab.

    var Dim=DS_1.getDimensions(Axis.ROWS)[0];

    var sel_val=CROSSTAB_1.getSelectedMember(Dim);

    if(Dim.text=="Division")

    { DS_1.setFilter(Dim,sel_val);

    DS_1.swapDimensions(Dim, "Sub_division"); }

    else if(Dim.text=="Sub Division")

    { DS_1.setFilter(Dim,sel_val);

    DS_1.swapDimensions(Dim, "Department"); }


    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded