I'm going to assume you don't want to make the filter global because there are other dashboards in the workbook you don't want to have these filters affect. You've got a few options:
- Upgrade to V8 (which allows selective 'global' filters, meaning you can select some or all sheets using the same data source).
- Duplicate the data connection, then rebuilt the two worksheets using this dupe and set the filter to global
- Use an action filter (these don't work exactly the same, but might be an option).
Hope this helps.
I have Tableau 8 but our tableau server has not been updated to support it so I am stuck with 7...
I will still to one set of data then. the solutions above seems to do the job but also a bit complex for the simple thing I am trying to achieve.