Can you give an example of the answer you are expecting if possible (narrow it down to filter condition,year and school level) ?
I need to be able to filter by grade band and aggregate values for just those schools that are within that grade band (i.e. total enrollment for all Elementary schools, or total capacity for all Middle schools), but in a way that doesn't require me to update my sets each year.
I have another filter that is also by school year, but that filter isn't a problem since it is one dimension with a unique value for each school.
Not certain what you expect - the data is a bit confusing - specifically there are several columns for enrollment that don't seem to be directly related to elementary or middle - ie sometime it is a single value repeated other times it is aggregate
here is what the model does - you want to use the same values in 2 different ways - counted as elementary and counted as middle
so I unioned a copy of the data upon itself
then in creating the viz you use one sheet for elementary and the other for middle
and then the same for labels
then you can use those values in any viz - just an example -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.