Forum Discussion
Drill Through Different Tables
I was just wondering how to drill through from one table to another table that contains different but similar fields. Basically both tables have an Account number and a month field. Table 1's month f...
serpiva64
Solution Sage
Solution SageHi,
have you Keep all filters selected?
Have you a Date Table and which is the relationship between Table 1 and Table 2? I think Month field in table 1 is not related to period.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Something like this? Also, which relationships should be active/inactive? I created a Date table with date, month_number, month_name. I created corresponding relationships to Table 1 and Table 2 from Date table. But still doing the same as before and not filtering by month, just account number.
