That's definitely possible. I believe you can accomplish this with a cross-table join. However a blend could work for you as well.
Here are two articles explaining joins and blends in Tableau in a lot more detail than I can cover in this single post:
If you have any questions about either though, let me know.