And Operator in Set Analysis

[Anonymous]

Is there and and operator in Set Analysis. For example I want a count of all of the people who took both Course1 and Course2.

Count({<[Course Name] = {'Course1', 'Course2'}>} Distinct [Employee ID])

gives me a count of the employees who have taken either course. I want only those who have taken both courses.

[swuehl · Accepted solution]

Try

=count({<[Employee ID] = p({<[Course Name] = {Course1}>}) * p({<[Course Name] = {Course2}>}) >} distinct [Employee ID])