I have a dashboard where there are 3 sheets, the first is high level data that you can filter on period and year parameters, the 2nd is for when you click on a particular spender in the first then the total of the spender is shown by vendor name...this works great. I am trying to incorporate the 3 sheet to give detail on that vendor's spend but only for that particular spender. I get just that vendor's spend ok but I get all the spend in the data base for all the spenders. I only want one person's vendor spend detail to show up. See below. How do I get only the vendor detail for the person I am clicking on to show up. I have tried Filter Actions to no avail. I am new to Tableau and it's probably something simple. Any help appreciated.
This has been figured out. We are sure why but we took out period and year from the detailed sheet...then it worked.