Forum Discussion

slewis's avatar
slewis
Helper I
7 years ago
Solved

Different Drillthrough Tables

I have a need: I have a summerized chart built from table A . I want to drill through to another page that takes it data from table B. Table A and B have simmilar fields (i.e. month and year). 

 

I want to be able to drill trough to that other page using the filter criteria from chart A onto table B. Is this possible and if so how?

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, slewis 

    Try this way:

    Add a bridge table for simmilar fields (i.e. month and year)

    Then create the relationship between A and B by bridge table.

    Now use month and year from bridge table in the visuals and set drill through by it.

     

    Best Regards,
    Lin

     

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, slewis 

    Try this way:

    Add a bridge table for simmilar fields (i.e. month and year)

    Then create the relationship between A and B by bridge table.

    Now use month and year from bridge table in the visuals and set drill through by it.

     

    Best Regards,
    Lin

     

    • slewis's avatar
      slewis
      Helper I
      7 years ago

      A bridge table like a custom date table? If I use the same bridge on all my tables then would that mean that drill through will appear with an option for every report tab?

    • slewis's avatar
      slewis
      Helper I
      7 years ago

      I used the custom Date table as the link. It works.