Use 'and' and 'or' in SET analysis on the same dimension

[#1]

HI there. Can anyone help a newbie a little?

I want to sum all "Answer" (1 or 0)  that has answered either '2_q10N1_1' or   '2_q10N1_2'  AND that has answered '2_q9b10N3_4' or '2_q9b10N3_5' for Answer_ID.

=sum({<Answer_ID={'2_q10N1_1','2_q10N1_2'} * {'2_q9b10N3_4','2_q9b10N3_5'} >}Answer)

Is there a way to do this?

Thank you

[Gysbert_Wassenaar · Accepted solution]

Maybe like this:

=sum({<Answer_ID={'2_q10N1_1','2_q10N1_2'}, Respondent_ID=P({<Answer_ID={'2_q9b10N3_4','2_q9b10N3_5'} >}Respondent_ID)>}Answer)

[#3]

Thank you Gysbert