Mar 02 2021 04:50 AM
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 drop-down list in another sheet.
Mar 02 2021 06:19 AM
Mar 02 2021 06:26 AM - edited Mar 02 2021 09:58 PM
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
Mar 02 2021 08:10 AM