Important Update: Community URLs redirect issues are partially resolved. Learn More. .

cancel
Showing results for 
Search instead for 
Did you mean: 

Help with listbox field filter

RodEhrlich
Contributor III

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.

 

Products.png

1 REPLY 1

Ilya_Khen
Champion III

Rod Ehrlich,

 

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.