You can use pivot table and Slicers, where the slicers will automatically grey out anything that is not relevant, otherwise you will likely need a lot of dependent lists.