I have a single report page with two tables. Both show basically the same fields, but the difference should be that one shows only records that have a particular field filled in ("Rank"), while the other shows those records that do not have this field filled in.
I have the tables setup with the correct filters, and they show the correct data based on those filters. The problem is if I click on a record in one table, it automatically filters the second table, looking for a matching record. Since the datasets are mutually exclusive, this means the second table is always empty until I clear the "click" on the first one.
I know I could put these visuals on separate pages, but I would like to have them together. Is this possible?
