Showing/Hiding/Modifying table on filtering

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.