I would like to change a table when a filter is selected.
Let's say a table of Car Dealership which each have Salespeople. I want a simple table with sales per dealership, and when a Dealership is selected from a dropdown I want to to show a table with sales per Salesperson.
What would be the best way to go about doing that? I'd rather not send the user to a different page.