You can connect your excel file with legacy connection and write custom sql statement to query your data from that. In your custom SQL you can use parameter in your WHERE clause which will restrict the data and pull the relevant information.
e.g In below example I've written a SQL statement and created a parameter based on [User] field.
then I've included [Select User] parameter in SQL statement to filter the data based on selected User.
Once done then go to your worksheet and select user from the parameter and check whether its returning the relevant information for that user or not.
Sample workbook v10.4 attached for reference. Let us know if this help.
Sample Param.twbx 11.0 KB
Mahfooj, that is very helpful.
Do i have to have a specific version of tableau to create a customer SQL connection? Going through the tutorial on Tableau, it mentioned that the excel file had to be created before Tableau 8.2, but my excel file is the latest version and was created yesterday. If you have any good resources of how to open the file with a legacy connection, please let me know.
Thank you for the help
Mahfooj, disregard the last point. I figured out the connection. Trying to work with the data now.
That's cool! Going forward if your required anything you can search here. Tableau KB article is very good source of knowledge.
If my given solution helps you to achieve the expected output then you can mark my answer as correct/helpful so that it may help others who have similar query and this thread will get invisible.