The FILTER() functions continue to reference the same source Table. When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure ...

How to add a filter to the interface in Excel The dropdown and search filters are good for you, but they’re not great for others who might be viewing the information in your pivot table.