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!