Forum Discussion
Link Pivot Table filtration with cell value
Hi Dears, How can link the filtration of the pivot table with a selection of specific value in a cell? Example: I have the below pivot table and in the date filtration need to linked with a dro...
Dear mathetes
I have attached the file and note the below:
1- In sheet "Officer" column "R2" the drop-down list for the date.
2- In sheet PVT, I'm looking to do a filter based on the selection of value in Officer!R2
I'm sorry.......I should have warned you NOT to post here (it's a public website) any real names of real people. You'll need to take that down. I also wasn't able to make the spreadsheet fully functional since it connects to some external sources.
As I noted in my first response, though, my sense is that you need to use that drop down in Officer!R2 to develop an intermediate table from which to develop your pivot table. You might find the new FILTER function very helpful in that connection. Here's a reference: https://www.youtube.com/watch?v=9I9DtFOVPIg
As I noted in my first response, though, my sense is that you need to use that drop down in Officer!R2 to develop an intermediate table from which to develop your pivot table. You might find the new FILTER function very helpful in that connection. Here's a reference: https://www.youtube.com/watch?v=9I9DtFOVPIg
- Thanks my dear,