I think GP is referring to something like excel’s filters, where the UI exposes filter options dynamically based on the data actually available after all existing filters have been applied.

https://docs.datasette.io/en/stable/facets.html (almost like a group by)