Set analysis, If customer purchase one of the product groups/ Proritization
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.