Add filter option for all your pivot table columns
How to add the filter option for all your Pivot Table columns? This article explains the trick and the technique
Create dynamic filter
How to use the FILTER function in Excel?
The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365