Multi-select filter based on condition

  • 1
  • Question
  • Updated 3 years ago
I have a model with a condition on the Status field to not show the option 'cancelled'. I then have a multi-select filter on a table looking to the status field, 'Cancelled' shows an option. Is there a way to not show the option in the multi-select since the option is filtered out of the table through a condiiton? 
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
*bump*
Photo of Joe Ort

Joe Ort

  • 2,256 Points 2k badge 2x thumb
Workaround could be to make the filter be off a Model instead of Automatic. Point the model to the same data set/filters.

I've done this with sales rep filters a few times successfully. 
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
Thanks for taking the time to respond. That is the exact solution I figured out last night. Thanks!