This will 100% depend on the structure of your data.
Please upload a Tableau Packaged Workbook including sample data so we can see what you have available as a starting point.
Please post a sample workbook. If you are doing tablea calculations then the comparison will depend on the way you are addressing and partitioning the particular filed.
I have attached an excel to share an example what I am trying to replicate in Tableau.
i would like to select a city from filter and show corresponding region in which that city falls in and show the comparative performance and also compare this with national total.
is this something possible?
comparitive example.xlsx 10.0 KB