Set analysis, If customer purchase one of the product groups/ Proritization

[#1]

Dear QV user,

I would like to ask for some help. I need to prioritize customers that purchase one of the three product groups (ex. proteins or calcium or magnesium). I thought I can do it by usage of set analysis, but cannot come with proper formula. I would like to include in a table extra column, that says 'yes' if customer purchased proteins or calcium or magnesium, otherwhise 'no'. Any ideas? Customer name is my dimension.

Thank you in advance,

Beata

[ManuelRühl]

Try this:

=IF(SUM($<{PRODUCTGROUP={A,B,C}>}TURNOVER)>0,'YES','NO')