Thank you so much, this is very helpful however, I do not want to separate the semester and the year into separate filters. I did tie in a field called date, which assigns a date to the term variable, however, I am still having issues getting the filter to display in the correct order. Basically, I would like the items of term description to display in the filter in the order of the dates instead of alphabetized.
I believe you can update the field order in the filter by right clicking on the field, hovering over Default properties, then selecting "Sort". You should be able to manually change the sort there.
As Ken mentioned in that other thread, if you have additional semesters added to this in the future, you'll have to manually sort that one as well. This method works best for a one time analysis where you won't have to resort again in the future.