I have two pivot tables in a file with the same database. I'm trying to filter the second pivot based on information from cell values in a first pivot. Clarifying, when I select cell E6 at first pivot (that is related to [Customer Name] = "Company C" and [Period] = "3", the second pivot will filter the [SalesPersons] and [Sum of Revenue] related to cell E6 (Company C and Period 3).