This can be accomplished by using a parameter as the drill down. I have attached a sample workbook with instructions showing how to do this.
Hope this helps!
Thanks for your reply Tracy. I am using Tableau 6.0 and can't open the file. Are you able to post an earlier version?
That worked. Thanks so much for your help!