- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I used the custom Date table as the link. It works.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-04-2024 01:59 AM | |||
09-18-2024 02:24 AM | |||
08-26-2024 08:55 PM | |||
10-24-2024 12:40 AM | |||
01-21-2025 03:01 AM |
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |