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 goals so when a user click on a specific city the goals and then sales from that city is displayed on the gauge that uses data from both tables however it only displays from the sales data and the goals data stays the same and does not automatically filter to the goals for the area. Is the relationship between the 2 tables should do this or I have to do something else?
2 Replies
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.
Proper relationship should help to achieve your requirement. You can also take measures into account, filling them into minimum,maximum,target of a Gauge visual.
Please be more specific if you'd like further advice.
