i have created marketing subcategories with the intent that we would be able to roll reporting up to the parent category.

But i am unable to see where i can select just the parent on a results column in my saved search. I had to use formula text field to even display the columns i need

Formula (Text)               REGEXP_REPLACE({category}, '[:^].*', ' ')             to display the Parent Category

and

Formula (Text)               REGEXP_SUBSTR({category},'[^:]+$')                   to display the Sub Category

but I am still not able to set the parent category as a criteria or a filter. what am i missing?