NOELHODGES
2 months agoQrew Cadet
Filtering a report for Combined Text Summary Field
I need to filter my report based on a Combined Text Summary Field called "Fruit Salad," which can contain up to multiple different options. I want the report to include only those records where more than one option is selected in the "Fruit Salad" field. For example:
- Record #1 has "Apple, Banana, Orange" selected.
- Record #2 has only "Apple" selected.
I want my report to exclude Record #2 because it has only one selection, and include Record #1 because it has multiple selections.
To summarize:
- Records with less than two selections in the "Fruit Salad" field should be filtered out of the report.
- Records with two or more selections should be included in the report.
This way, my report will only show records with multiple selections in the "Fruit Salad" field.