Use the OR Operator between filters

[StavrosMcGillicuddy]

My dashboard has several drop-down filter panes

As filter panes are “or” within themselves, using two or more filter panes are “and” between them

(Filter A(1 or 2 or 3)) AND (Filter B(4 or 5 or 6))

I need to add Filter C with an OR operator like this.

(((Filter A(1 or 2 or 3)) AND (Filter B(4 or 5 or 6)) OR (Filter C(7 or 8 or 9))

Filter C must be available to use with any of the other filters on my dashboard

I tried adding Filter C 7,8,9 into Filter B like this 7C,8C,9C. It works but it's clunky and not intuitive.

Is there a cleaner way to do this? Maybe dynamically build a search string that can be edited like SDFC & Marketo?

[Qrishna]

Hi - some sample data and needed output pls? Filter as in the Filter pane object or the field name in the script?