Forum Discussion

busybee's avatar
busybee
Icon for Helper I rankHelper I
6 years ago
Solved

Drilldown from matrix to matrix

I have a parent matrix and a drilldown matrix on the same page of my report. I have 2 measures as Values in the parent matrix. When I click on one of the values, it does not drill by just that value but both the values. I would like the parent matrix to drill down the child matrix by only one value. Any suggestions?

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    busybee are these both matrix are from same table? What is the measure you are using for value? Can you share the screen shot showing what is not working and what you expect to happen?

    • busybee's avatar
      busybee
      Icon for Helper I rankHelper I
      6 years ago

      Both the measures are from the same table. I have added them to the Values section of the parent matrix. When I click on one of the measure value in the parent matrix, the child table filters data from both the measure values instead of one.  

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        6 years ago

        busybee it is filtering on the row not on the cell value you have selected.