Hi everyone,

How can you make a filter in a pivot table set according to user input.
I have a pivot table with set of accounts and their information in different columns like reps, city, etc

How can i make it so on gettin input from a user the filter on say the city would change. so say if the user enters a city in one cell above the table, the pivot table filter would change to that city and show only those values. I hope that kinda explains what im tryin to do ? Any help is greatly appreciated. Thanks !!