Exclude options in automatic filter where there are no records in my model with those values

Automatically generated filters are great! But I must be missing something, because I don’t want to show options that would filter for 0 records.

How do I exclude options from the filter if the model does not have any records that match that value

Also, any idea why my “Other” option wouldn’t be showing here?

Use an aggregate model and snippet to generate the options. Can even include the qty in choice.

Awesome! Didn’t even need the Snippet, I just used a filter with Select Option - Manually, and used Rows in a Model (with the aggregate model) as the Option Source

Awesome!