Spotifre Filter COnditions

[San Ram]

Hi,

In my SPOTFIRE report, I added threesearch boxes.

When I'm entering the data in first two search boxes, the o/p shows as the "OR" condition.

For Eg:

If I given in dept_id as 20, 30 in the first search box and I give in Supervisor_name as "ROBERT"in second search box. I'm seeing records which has both the search box conditions.

that means all the records withdept_Id (20, 30) OR records with Supervisor_name (ROBERT) is displayed.

Expected Result:

I want to see only the records which have dept id(20, 30) AND Supervisor_Name("ROBERT").

 

Any help is appreciated.

Thanks,

Ram

[Kirsten Smith (she/her)]

You could create a calculated column with something like:

 

case when (doc1)=20 and (doc2)=Robert then 'yes' else 'no' end

 

Then filter out all of the 'no' entries