1. I have two files, both with a common field called Risk Type and Organisation Level. I will only like to sync the Risk Type. Where can I sync the field in Tableau? (I can do it easily in Qlikview as long as the name is similar)
2. On top of that, I have another file with two field (Organisation Level and Division). I would like to lookup the Division into both above files based on Organisation Level. This division will be synced for the above two files
3. In the end, the final chart will look like in the Result sheet attached. They will be bubble instead of numbers.