Create search parameter
create calc as
Drag subcategory into view. drag this into filter and select true.
Now search and get results.
If you want to go with wildcard match then drag the dim into filter and select wildcard search with starts with option.
Type S* and only S started letter data.
Thanks for sharing the above information but with parameters we can select only one value. My requirement is to select multiple values in filter.