How to fiter Query Table using report as a filter?
Greetings!
I have a dashboard with multiple reports and all of them are acting as a filter. Everything was working fine.
So I created a Query Table to join data from different tables and show as a list of items into this dashboard. The main purpose is to show to the user wich data are in those reports. Now, when I use a report as a filter, all other reports are filtered as well, but not that Query Table. The strange part is when I use that Query Table to filter the dashboard, it's works (all other reports are filtered).
I created a lookup relationship between query table and the fact table of this dashboard, but I still facing this issue.
There are something that I missed out? Is there a way to filter a query table using others reports as a filter?
Thanks in advance