I have a (messy) data set with a number of fields (variables) that each constitute a school district (each defined by that district name) within which each observation is a particular school within that district or null if the school is within another district and thus another field. I need to create a nested filter whereby users can first select their school district and then select their school from within that district. Not quite sure how to do this... any help greatly appreciated!
Aaaaah... that's clearer. You're honestly going to be best served here by pivoting the data.
The only other way I can think of to do this is to create a parameter which has all of the districts as values. Based on which option the user selects, you look up the corresponding column. But you will have to write out a line for every district, which could be quite tedious... i.e.
If [Parameter] = "Carlsbad Unified" THEN [Carlsbad Unified]
Then you would place this field as a filter. But again... tedious, and won't scale well, or at all to new districts. Pivoting is a much better option if you can.
