Filter On Measured Results in Straight Table

[DataHound]

Hello all,

I have a question regarding creating a filter for a calculated results. The column I intend to filter is in a straight table, but I would also like it to apply across the application like filters usually work when applied.

The column I am looking to filter is currently showing a measurement. As discussed in another post, this measurement is showing a calculated result based on variables.

The formula I have in the column is working great, but I cannot find a way to filter on , and I’m not sure if it’s possible. Do I need to do an Inline load? Or create another variable?

Current Measurement Column I wish to filter by:

Pick(1+($(Criteria_1_Indicator)*2) + $(Criteria_2_Indicator),'Not Eligible','Criteria_2','Criteria_1','Both') 

I’d like to have the filter drop down, or other method present the four options of:

'Not Eligible','Criteria_2','Criteria_1','Both'

Any help would be appreciated!

Thanks!