I have a container with two chart tables. Each chart tabulates data from unrelated tables. I want to use a filter which can be used to filter a field from each of the two tables, depending on which report is chosen. So if i choose report 1 from tab1 , i want the filter to use a field from table 1, If I choose report 2, the filter should use a field from table 2.
Since i can't overlay filters, this would be to do double duty with a single filter. Because screen space is limited, i do not want to use 2 separate filters. I have tried: =Pick(Match(ReportTitle,'Report1','Report2'),tbl1LookupField,tbl2LookupField). but the filter dropdown does not populate.
