I have a whole mess of standardized test scores for different subjects, for students at different grade levels and in different districts. I'm having difficulties with my second dashboard: District Trends.
I don't have data for every possible permutation of filter options. For instance, the Science test is only given to students in a couple of the grade levels. Is there a way to set up the filters so that if someone selects a given subject the grade filter only shows grades for which data is available?