Forum Discussion

slewis's avatar
slewis
Icon for Helper I rankHelper 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...
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

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity 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
Icon for Helper I rankHelper I
7 years ago

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