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

Conlan O'RourkeConlan O'Rourke Member ✭✭
edited June 25 in Questions
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 
image

Also, any idea why my "Other" option wouldn't be showing here?


Comments

  • Pat VachonPat Vachon Member ✭✭
    edited June 25
    Use an aggregate model and snippet to generate the options. Can even include the qty in choice.
  • Conlan O'RourkeConlan O'Rourke Member ✭✭
    edited November 2017
    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

    image
  • Pat VachonPat Vachon Member ✭✭
    edited November 2017
    Awesome!
Sign In or Register to comment.