You would have to do it as a join and use the username=USERNAME() as a data source filter.
Hi Sara Fuller
You can restrict from data source.
Filter a data source
Rather than maintain user filters and special permissions on each published workbook, you can filter a data source, and then publish the data source to make it available as a shared, one-to-many resource for anyone who uses that data.
This procedure builds from the dynamic-filter approach described in this topic.
- Complete the steps in Create a dynamic filter using a security field in the data.
- In the lower-left area of Tableau Desktop, select the Data Source tab.
- In the upper-right area of the Data Source page, under Filter, click Add.
- In the Edit Data Source Filters dialog box, click Add, add the calculated field you created for the dynamic filter, and set the filter to True.In our examples, this is the User is a manager field.Click OK until you get back to the Data Source page.
Please mark this answer as correct or helpful to close the thread
BI, Aspire Systems (India) Pvt Ltd