Limit filtering of a visual RRS feed

  • Question

  • I have 2 tables.  I  want to use 1 as a Filter and 2nd to view data.     in table 1 (left side), i want to select a Bank ID (or row) to filter the right hand table on BUT i dont want the dates to be filtered out of table 2 (right side) i want to keep all dates. but show only BankID selected in table 1

    from what i understand, using FILTER functions is more about the values that are produced.  i feel i am looking for a visual solution, that I can keep dates in table 1 (as a reference) but select the BankID (or row) and only filter table 2 by Bank but not by date 9keep all dates).   I guess I need an ALL EXCEPT on my page filter.  not sure, any solutions?


    Tuesday, September 11, 2018 3:24 PM