Important Update: Archer Community Scheduled Maintenance on November 23–24 - New Community Launching Soon! Learn More..
2020-05-20 02:18 PM
We have a listbox field values list. Each record can have more then one value. We are having a problem drilling down to specific values in the report filter. Example a record has value X Y Z. If I search for just X and Y I will get the record that has X Y Z. I only want to see records with specific values X Y. I am not sure if we can even do that in the report filter.
In the example below I don't want to see the record circled. I only wanted to see records that only had Medicare PPO and Medicare PPO w/PDP.
2020-05-20 04:23 PM
I think it can be done in the Report via FILTER, you need to setup the 2 filter fields to CONTAIN these 2 specific values and DO NOT CONTAIN all other values. 2 filters will be related as AND.