2 conditions on same field

[stevejones1]

Hi

I have a field for Status which has the values 'closed','Confirmresolve','resolved'

i need to create a filter on CaseStatus which should have 2 values CVACLosed and Closed

Closed should include all 3 statuses

CVAClosed should only include 'Closed' and 'Confirmresolve'

How do i write an expression for CaseStatus field?

Thanks!

[Digvijay_Singh]

What if you create new island table having field CaseStatus and associate it with field Status like this -

CaseStatus:

Load * inline [

CaseStatus,Status

CVACLosed,Closed

CVACLosed,Confirmresolve

Closed,Closed

Closed,'Confirmresolve'

Closed,'resolved' ];