When setting up a filter action in a dashboard, it only allows me to select a specific field from the worksheets main data source. How do I filter on a field that is a related table (an connected in the worksheet)? Otherwise, is there a way to change the primary table for an existing worksheet?
One way would be to create another worksheet with only the field from the secondary source on it and create the action from that to the other sheets.
Hope that helps!