First time asker, forgive me if I get anything wrong. I'm working on a big-data enterprise product that has many filters to allow the user to find what they want in a table with thousands of rows and 20+ columns. Every column is filterable, and columns might include "Price Range," "Weight," etc. Out of these dozens of filterable columns, two in particular are what I'd like to ask about: "Category" and "Subcategory." These two filters, as you can imagine, have a close relationship.
As the UI works right now, Subcategory's available options to filter from are unaffected by Category's selection. A user could filter by the Dairy category, for instance, and still see Subcategory options that might include "Cookies" or "Beef", for example.
What is the convention that I should follow in this case? Keep the filters independent of each other (like all other filters) or make these filters dynamically populate one another (either one way or both ways)? I'd be interested in your thoughts/any examples in the real world you see where some filters affect other filters, and other filters don't affect others, all in the same table.
Thank you in advance!