Forum Discussion
Solved
Filter Relative time data - not related tables in a matrix.
Hello, I need assistance in filtering the data without a direct relationship between tables. We have three tables: Sales Time (which contains calendar data) Relative Time (loaded daily with r...
This is one of the few occassions when you want to use a bidirectional filter. Make the relationship between Time and Relative Time bidirectional, so that when you place a filter on Relative Time that filter will reach the Time table, and ultimately Sales.
johnt75
Super User
Super UserThis is one of the few occassions when you want to use a bidirectional filter. Make the relationship between Time and Relative Time bidirectional, so that when you place a filter on Relative Time that filter will reach the Time table, and ultimately Sales.
Thank you. It worked.