Forum Discussion
Filter Data from 2 tables
Hi all I have 2 tables one is items sold (sales) and the other is sales goals (goals), they are related, I have created most of the reports for table one data but I want to make the gauge for the...
I'm a bit old school here. It could be that bi-directional cross filtering can handle this easy for you.
But, as an old schooler... I would have a separate "lookup table" for the cities. That table (with 1 city per row), is then related to both of your current fact tables. Then filtering cities in that lookup table, will magically filter rows in your two fact tables.